Don't Plot Point but leave in Data Table

  • Thread starter Thread starter mebp
  • Start date Start date
M

mebp

I don't want to plot a couple of points in my chart but like to keep them in
the data table. How can I accomplish in MS 2007?
 
EXCEL 2007

Try the following (I have a bar chart on the screen in front of me as I do
this. It has 9 countries on the Y axis; I will remove 2 of those countries).

1. Click the graph to highlight it.

2. Select Data.

Select Data Source window launches.

3. Hit the:-

Switch Row / Column button

4. I now have my countries in a list on the left hand side.

- click on France and hit Remove

- click on Germany and hit Remove

5. Hit the:-

Switch Row / Column

- button once more.

OK.

6. France and Germany now no longer appear on the chart.

If my comments have helped please hit Yes.

Thanks.
 
Could you format the points to make them invisible (no lines or markers,
no borders or fills)?

- Jon
 
Back
Top