ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Axis Values Keep changing (https://www.excelbanter.com/new-users-excel/205455-axis-values-keep-changing.html)

jayceejay

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?

Bernard Liengme

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?





All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com