On May 2, 2:02*am, 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

It's not quite clear what you want, Pete. if you want to be able to
choose combinations of two series and put them on the same graph, one
way is to make a set of two dummy variables to hold the series you
want and draw the graph of them. Then you can use two drop down boxes
to select the series you want and use OFFSET to copy the picked series
into the dummy positions.