+ Reply to Thread
Results 1 to 5 of 5
  1. 06-10-2009, 07:19 PM #1
    Dave69rock
    Dave69rock is offline
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Excel 1997
    Posts
    156

    Change Chart data based on column selected

    Hi
    I have a data table with lots of column headers
    Is it possible to have just one Chart to display my percentage results just for the column i've selected.

    Please see the the attached sheet

    I don't want to have 30+ charts if i can just change the name in a cell and have one chart.

    Dave
    Attached Files Attached Files
    Last edited by Dave69rock; 06-12-2009 at 02:47 AM.
    Reply With Quote Reply With Quote
  2. 06-10-2009, 09:51 PM #2
    teylyn
    teylyn is offline
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Change Chart data based on column selected

    Hi, can you please post a smaller work book? I'm on a data plan and will not open big files.

    Without looking at your spreadsheet, you should look at using a range name for the series you want to chart and have the range defined dynamically.

    Check out Jon Peltier's pages about dynamic charts to get some more ideas.

    http://peltiertech.com/Excel/Charts/Dynamics.html

    HTH
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
    Reply With Quote Reply With Quote
  3. 06-10-2009, 11:42 PM #3
    Dave69rock
    Dave69rock is offline
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Excel 1997
    Posts
    156

    Re: Change Chart data based on column selected

    hi

    Please find attached

    Dave
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  4. 06-11-2009, 07:00 PM #4
    teylyn
    teylyn is offline
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Change Chart data based on column selected

    How about this?

    All explanations are in the file ...
    Attached Files Attached Files
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
    Reply With Quote Reply With Quote
  5. 06-12-2009, 02:47 AM #5
    Dave69rock
    Dave69rock is offline
    Forum Contributor
    Join Date
    08-22-2008
    Location
    S-o-t
    MS-Off Ver
    Excel 1997
    Posts
    156

    Re: Change Chart data based on column selected

    Hi

    This is fantastic just what i'm looking for

    Many thanks

    Dave
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0