Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display non-numeric values in a scatter chart?
I'm trying to put together a scatter chart showing non-numeric magnitude, in
this case I want the axes to indicate 'least feasible-most feasible' and 'largest impact on poverty-smallest impact on poverty'. I presume that to do this I must in some way attach two numeric values to each data point which I have done, but I don't want this to be displayed numerically in the chart, I only want to show each point relative to another. Is this possible? Many thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display non-numeric values in a scatter chart?
1. You need to assign numerical values to the quantities to be plotted.
2. You can hide the axis tick labels so no numbers appear: Double click the axis, Patterns tab, choose None for Axis Tick Labels. 3. You can use textboxes to place your labels on the chart, or perhaps create a fake axis with the labels you want as its data labels: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "iaintw" wrote in message ... I'm trying to put together a scatter chart showing non-numeric magnitude, in this case I want the axes to indicate 'least feasible-most feasible' and 'largest impact on poverty-smallest impact on poverty'. I presume that to do this I must in some way attach two numeric values to each data point which I have done, but I don't want this to be displayed numerically in the chart, I only want to show each point relative to another. Is this possible? Many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY Scatter Plot - Non-numeric data | Charts and Charting in Excel | |||
how do i show non-numeric values graphically in a chart? | Charts and Charting in Excel | |||
Scatter chart without numerical values | Charts and Charting in Excel | |||
I want to ignore invalid values in scatter chart | Charts and Charting in Excel | |||
BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) |