Don't Plot Point but leave in Data Table
 

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?

Don't Plot Point but leave in Data Table
 

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.






"mebp" wrote:

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?

Don't Plot Point but leave in Data Table
 

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/17/2010 11:15 AM, mebp wrote:
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?