Forum Discussion
Using same dataset for multiple charts
Hello all, I'm embarrassed to be asking this because I use to be pretty good with Excel but I need help! I need to create multiple charts from data in my worksheet. Data source for a chart is define...
Jazzlover yes, you can use the same dataset to create multiple charts, just select your dataset then Insert > Charts to create/insert a new chart. The way Excel works (and that made us a little bit confuse) is the new chart is created in the exactly same size and placed overlay with previous one. You will need to drag the new chart, move it to the new place and now you will have multiple charts for same dataset as illutrated in the following snapshot