On Wednesday, May 2, 2012 2:02:51 AM UTC+12, Peter Lyons wrote:
Afternoon everyone,

I have created a number of charts that plot information across 26 weeks
and 4 data series'.

The issue I have is that I would like to create a macro or command to
display one of the series at a time in the same graph. If possible all
combinations so any two series can be compared against each other. just
it can seem messy to some of the viewers if they are not 100% about what
they are looking at.

Is this possible and if so how is it best done as all attempts I have
had so far at recording a macro have come to nought?

Many thanks in advance,

Pete




--
Peter Lyons

Another way which sounds like what you want is to have your data with a toggle button above each column which you click if you want that series to appear. You can do this by actually graphing a dummy series. Say that the real data is in in B3:B10 and you have a toggle button which puts a TRUE into B1 if you want the series to be plotted (otherwise a FALSE). Put the dummy data over in say F3:F10. F3 reads =if($B$1,B3,#n/a) and copy this down.. This is the data you plot. If B1 = TRUE then the graph is visible. if B1 = FALSE the the graph disappears. Repeat for the other columns.
To put a toggle button in for Excel 2007, you will need to go into options and get the Developer pane visible. It probably already is if you are writing macros. Then Developer - Controls - Insert - ActiveX - Toggle Button - drag and outline - right click - Properties - Linked Cell B1 -
Design Mode off.

Or, send me a copy of the sheet as it is to the.christies at clear.net.nz and I'll give you an example.

D