Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
scatter plot data point labelling question | Charts and Charting in Excel | |||
How do i plot a data set that has one data point missing | Excel Discussion (Misc queries) | |||
How do I plot two columns of data as one data point/marker in a ch | Charts and Charting in Excel | |||
scatter plot & label for a data point | Charts and Charting in Excel |