Showing or Hiding Series

**Faolan** · 07-30-2007, 02:11 PM

Is there any quick way to select which series, or sets of series I want a chart to show?

I have made a dynamic chart (with great help from broro183) that charts 4 series of data. I may want to show 1 series, or a combination of 2,3, or 4. I put in a control box, but that is really throwing off the data, for a reason I cannot figure out.

FYI, because of the way I receive the data, I have date headings across the top row, the 4 series of data in 4 rows below that. I know, I know...it would be more elegant to have it in columns, but I really don't want to go through the hassle of transposing into columns.

Thanks in advance.

**Bryan Hessey** · 07-30-2007, 06:34 PM

Originally Posted by Faolan

Is there any quick way to select which series, or sets of series I want a chart to show?

I have made a dynamic chart (with great help from broro183) that charts 4 series of data. I may want to show 1 series, or a combination of 2,3, or 4. I put in a control box, but that is really throwing off the data, for a reason I cannot figure out.

FYI, because of the way I receive the data, I have date headings across the top row, the 4 series of data in 4 rows below that. I know, I know...it would be more elegant to have it in columns, but I really don't want to go through the hassle of transposing into columns.

Thanks in advance.

Hi,

it sounds like the easy way would be to Hide the rows that you do not want to see, you could record 5 macros and use Shortcut keys to Unhide all, and Hide each, row.

hth
---