Hide Data in Chart

[ryan_law2000]

Hey Everyone, Im fairly new to excel charts so bare with me.

I have selected a range of data for my bottom row. This contains 20 cities. I only need 10 of these cities to be showing though. (Not all beside eachother so i cannot just select a different range, I also can not change the order of the data)

How do I either:

Hide individual Cities on the bottom row?
or
Select Individual Cells when entering the data? ( i have tried just selecting a cell then "+" then another cell and so on but this gives me a error.

Thanks for you help in advance!

 

[CWatts]

Assuming your data is like this, one option would be to use Auto Filter

Just highligh your table, turn on auto filter and then remove the check mark from the cities you do not want displayed in your chart. And it's easy to add and remove as your data changes.

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>City</TD><TD style="TEXT-ALIGN: center">Count</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Boston</TD><TD style="TEXT-ALIGN: center">3</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Memphis</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Las Vegas</TD><TD style="TEXT-ALIGN: center">5</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Tampa</TD><TD style="TEXT-ALIGN: center">6</TD></TR></TBODY></TABLE>

 

[ryan_law2000]

all My data is in row 1 going across the screen so filter would not work.

 

[ryan_law2000]

Another problem with hiding the columns is that the other 10 cities I want to hide will be on a different chart. So i need all the data to be showing

 

[CWatts]

In that case you're looking at hiding the column with the City you want to hide, or you can use that row of cities to populate a "hidden" data source somewhere that is formatted like my avove example.