Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quasi Transpose / Stacking Columns | Excel Worksheet Functions | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel |