Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Axis Values Keep changing
I have a scientific table of values containing time increments as column
entries (0, .5, 1.0, 1.5, 2.0, etc.). There is a corresponding record entry for each of these time increments. When I attempt to create a CHART, however, that range of values changes to 1, 2, 3, 4, etc.). I've played with changing the increment values to number format, and I can't seem to get beyond what excel's chart wizard insists upon doing to this range of values. Any suggestions? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Axis Values Keep changing
You have been making a LINE chart when you need an XY chart
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "jayceejay" wrote in message ... I have a scientific table of values containing time increments as column entries (0, .5, 1.0, 1.5, 2.0, etc.). There is a corresponding record entry for each of these time increments. When I attempt to create a CHART, however, that range of values changes to 1, 2, 3, 4, etc.). I've played with changing the increment values to number format, and I can't seem to get beyond what excel's chart wizard insists upon doing to this range of values. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Axis - How to remove percent sign without changing values? | Charts and Charting in Excel | |||
Data labels along below x axis when y axis has negative values | Charts and Charting in Excel | |||
Changing values of x-axis to include greek letters | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |