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?
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)
