If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Series Name
I have a table that is set up using "Data-Filter-AutoFilter" so that the user
can click a drop down arrow in the header for column 1 (the x-values), select a value, and the table displays only those records. A chart is connected to the table. In the chart I want the series name to be the user's choice of the dropdown value. For example, say the x-value choices are "apples", "oranges", or "lemons". If the user chooses "oranges", then that becomes the series name in the chart. Can someone come up with a way to do this. I have thus far done all this without VBA, and prefer to leave it that way. Thanks, Art |
#2
|
|||
|
|||
Hi Arthur,
If you open a chart and select one series (by single clicking it) the formula bar will show something like this: =SERIES(Label,X-Range,Y-Ranges,Series No) Label is the series label, can be a cell reference or a label enclosed in quotes X-Range is a range, usually given in the form Sheet1!$C$5:$M$5 but it could also be a series of numbers such as {5,6,7} or a reference to a range name such as Sheet1!Sales Y-Range is similar Series No is an integer giving the z-order of the series Change the Label to a cell reference like Sheet1!C1 (You can do this by selecting a cell). If the cell reference is the same cell that is used by AutoFilter to select "oranges" then you have what you want. Ed Ferrero http://edferrero.m6.net "ArthurJ" wrote in message ... I have a table that is set up using "Data-Filter-AutoFilter" so that the user can click a drop down arrow in the header for column 1 (the x-values), select a value, and the table displays only those records. A chart is connected to the table. In the chart I want the series name to be the user's choice of the dropdown value. For example, say the x-value choices are "apples", "oranges", or "lemons". If the user chooses "oranges", then that becomes the series name in the chart. Can someone come up with a way to do this. I have thus far done all this without VBA, and prefer to leave it that way. Thanks, Art |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need help updating chart (series in dynamic range) | Jeff | Charts and Charting | 1 | April 1st, 2005 02:35 AM |
SHARED SOLUTION: Horizontal lines on XY Scatter w/multiple series | LeAnne | Charts and Charting | 1 | November 15th, 2004 02:35 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
What VBA Stmt Will Tell Me the Index of a Chart's SERIES Formula? | SidBord | Charts and Charting | 2 | June 23rd, 2004 07:26 PM |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |