+ Reply to Thread
Results 1 to 10 of 10

Extracting data from graphs

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    89

    Extracting data from graphs

    I have several graphs(stacked) that show data from different time periods. one showing data from 01.2013-03.2013 etc. For each of these graphs there is an additional sheet showing the data for them. is it possible to extract the data from the graph without using the second sheet where the data is listed? if so i could half the amount of sheets i have to use.
    I need to make one stacked graph showing period on the x axis, and then have the respective stacked collumns over them.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Extracting data from graphs

    Isn't it possible to make the graphs from a summary sheet?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Extracting data from graphs

    what im doing is; every 3 months a report is made, and it is on 3 sheets. on the 1 st sheet is graphs of the data on the second and third sheet + some other information not shown in the latter 2 sheets.
    So far i have been using all 3 sheets, but im already up to 30 sheets, and would like to be able to remove 2/3 of them if possible. and if i could take the data from the graphs, 2 of the sheets could be removed.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Extracting data from graphs

    Could you add an excel file, without confidentional information.

    Please also add the desired (expected) result.

    I can't promise you, I have an solution for you, but I will take a look at it.

  5. #5
    Registered User
    Join Date
    07-03-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Extracting data from graphs

    the first sheet is the graph im looking to create.
    Sheet1: some of the data from sheet1 on the report
    Sheet2: What one of the graphs is based on
    Sheet3: ^
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Extracting data from graphs

    And where are the data you based the graph on?

    In your example i don't see any date, how do we know which section (quartal) it is in.

    You need to provide more info.

  7. #7
    Registered User
    Join Date
    07-03-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Extracting data from graphs

    Sheet 1-3 is the data for the first 3 months in 2012. There are several "3 sheets" identical to these, whith different numbers ofcourse. The graph i wanted is based a table i made that collects data from sheet:3,6,9,12... etc to make an overview like i showed. however this same data is shown on one of the charts in sheet1. Is it possible to ignore sheer 2-3's and just get the data straight from these charts?

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Extracting data from graphs

    I don't know if you can achieve this straight from the charts.

    But as alsready said, why not create the new graph, from a summary sheet?

  9. #9
    Registered User
    Join Date
    07-03-2013
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Extracting data from graphs

    thats what i have done, but this means i have to keep all 3 sheets for each report, making me use 3 times as many sheets. what i would like to do is just use sheet1, and then just delete sheet 2and3

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Extracting data from graphs

    Then show an excel file, without confidentional information, but with also the date / more sheets etc.

    The file you use, without confidentional information.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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