+ Reply to Thread
Results 1 to 4 of 4

Need help on adding chart data from different Tab

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need help on adding chart data from different Tab

    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

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,823

    Re: Need help on adding chart data from different Tab

    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.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need help on adding chart data from different Tab

    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.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,823

    Re: Need help on adding chart data from different Tab

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding data values onto a pivot chart
    By ACrossley1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-11-2014, 02:16 PM
  2. [SOLVED] Pivot Chart adding data together in line chart
    By jennieS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2013, 05:37 AM
  3. Adding More Data to a Stacked Chart
    By Phillycheese5 in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 07-01-2011, 03:33 AM
  4. Adding more data labels to pie chart
    By ctolson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-25-2010, 10:21 AM
  5. adding data over existing chart
    By Diesel13 in forum Excel General
    Replies: 1
    Last Post: 03-04-2010, 10:30 AM
  6. adding information to chart data
    By andreas_d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2007, 02:26 AM
  7. adding data to a chart
    By inquirer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2006, 04:45 AM
  8. Adding Data Information to a Chart
    By Mike M in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-16-2005, 08:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1