If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|