Need help on adding chart data from different Tab

**Kalaiselvan K M** · 08-07-2015, 05:32 AM

Hi,

Assume i have 3 tab and all 3 tab have same format, I have made plots using data from tab1. and now i just want to add data from tab 2 also to the same plots(Multiple plot, i don't want to go to individual plot and add data one by one). Is there a way to do this.

Regards,
kalai

**Kaper** · 08-07-2015, 05:37 AM

Create plot with data from one sheet then add new series to the plot and include data from second sheet in this series.
The same with third one.

**Kalaiselvan K M** · 08-07-2015, 06:32 AM

Thanks Kaper,

But I have close to 100 plots, going to individual plot and adding a series will be tedious. Is there a way out.

**Kaper** · 08-07-2015, 07:34 AM

Record a macro while you add one plot then edit it to 1) run in a loop for your 100 sheets 2) use appropriate sheet as data source and plot placement for every plot.

Need help on adding chart data from different Tab

LinkBack

Thread Tools

Rate This Thread

Display

Need help on adding chart data from different Tab

Re: Need help on adding chart data from different Tab

Re: Need help on adding chart data from different Tab

Re: Need help on adding chart data from different Tab

Thread Information

Users Browsing this Thread

Similar Threads

Adding data values onto a pivot chart

[SOLVED] Pivot Chart adding data together in line chart

Adding More Data to a Stacked Chart

Adding more data labels to pie chart

adding data over existing chart

adding information to chart data

[SOLVED] adding data to a chart

Adding Data Information to a Chart

Bookmarks

Bookmarks

Posting Permissions