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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Surpressing plot of blank cells 3
Plotting data points on 2 axis 4
Not plot a data series in a chart but still display in data table 1
bubble charts from an excel cube function table that randomly fail 1
Scatterplot with background area plot 4
2nd axis plotting incorrectly - is there a chart size limit? 2
Chart does not render plotted points correctly, data comes from a 3
Repeating gradient for each vertical area of plot area 3

Back
Top