login about faq

I have created a bunch of series in my excel plot. I would like to have ability to retain these series but only select the one that I'm interested in to look at. Presently when I try to select the one that I'm interested in I have to delete other series. And every time I need to select a series which was deleted I end up creating again (which takes time and really unnecessary). Is there a way I can retain all the series and select the one that I'm interested in without having to delete the other series.

asked Jul 18 '12 at 10:35

pluto99_999's gravatar image


If I understand you correctly you are removing the data series from the chart so that they don’t show.

All you need to do for any data series that you don't want to view in the chart is hide the columns or rows where the data series are held then they wont be displayed in the chart

Then to show them in your chart again you just unhide the columns or rows that contain the data you want included in the chart.


answered Jul 18 '12 at 17:29

Simon%20H's gravatar image

Simon H

edited Jul 18 '12 at 18:10



(Jul 20 '12 at 09:54) pluto99_999 pluto99_999's gravatar image

Try Microsoft excel 2007 and check out


answered Jul 20 '12 at 08:37

julieandrews's gravatar image


Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: Jul 18 '12 at 10:35

Seen: 1,351 times

Last updated: Jul 20 '12 at 09:54

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact