Don't Plot Point but leave in Data Table

[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?

 

[trip_to_tokyo]

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.

 

[Jon Peltier]

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

- Jon