98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Combining data from two different tables
Combining data from two different tables
· High Priority · Version 365
Fri 8 Nov 2024, 15:55Delegate Katie said...
Katie has attended:
Excel Intermediate course
Combining data from two different tables
Hi Jens
Today I have tried to combine data from two different Excel tables into a chart but I can't figure out how we did it during the course. Are you able to help?
Tue 12 Nov 2024, 09:11Trainer Martin said...
RE: Combining data from two different tables
Hi Katie,
Thankyou for your question to the forum.
To combine data from 2 tables to a chart you will need to first create the chart type you want from a blank cell and then click SELECT DATA from the Chart Design tab in the ribbon. The next bit is a bit trickier to explain without some visuals to guide you so I suggest you follow along with this helpful Youtube video:
https://www.youtube.com/watch?v=5CyXfAzOsQQ
I hope this works. Please let me know if it has helped or if you need more help.
Kind regards
Martin Sutherland
(IT Trainer)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:3D formulas find and replaceAfter you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be. |
