+ Reply to Thread
Results 1 to 2 of 2

One trend graph, but multiple regions

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    One trend graph, but multiple regions

    Hello,
    I have a pivot table of multiple regions, about 20. For each, by month, I have both actual and budgeted overtime data. I'd like to create just one graph that trends the actual to the budget, for just for a single site at a time. I'd like the give the users the ability to click on their particular or interested site and see the graph just for that site. click on another site, and the graph changes for that site's data. Is this possible? If so, what do I need to do? In the past, I've just created 20 graphs. thank you.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,891

    Re: One trend graph, but multiple regions

    Forum search (or Google (other search engines are available)) for "Dynamic Charts".
    That should bring up lots of information on this.

    If you have no luck with that, post some sample data here and we'll gladly help further.

    BSB.

+ 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. [SOLVED] how do I create a bar graph with a trend line?
    By moshingbananas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2012, 10:35 AM
  2. Scatter plot : highlight multiple regions of the X axis
    By Virgule in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-15-2012, 05:52 AM
  3. Trend Graph from values on a single raw
    By TRS in forum Excel General
    Replies: 2
    Last Post: 04-04-2011, 10:39 AM
  4. Trend graph with series
    By holmes123 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-31-2011, 09:25 PM
  5. Trend line on graph name
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 12-17-2010, 08:19 AM

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