X axis does not display correct data point "with formula"

M

mcuoidellum

Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When using data generated from formula in xy scatter, the x axis values do not display as the correct values. The y values are correct, but the program decided to throw in some random values for the x values (1-10).
Graph does plot correct values when inputed directly without being created by a formula: when formulated data values are copied and special pasted with the number values only, without the formula creating that numbers the correct x values are plotted.
 
M

Mike Middleton

mcuoidellum -

If any values in the X range are text, Excel will use X values 1,2,3,... for
the XY (Scatter) chart.

So, maybe some of the results of your formulas are being interpreted as text
instead of numerical values.

For more assistance, please provide more details: Excel version, formulas,
and cell contents to which the formulas refer.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining x-axis values NOT labels in column charts ExCel 2008 1
how to edit my x-axis data on a line graph 0
Charts - Declaring different X-axis values for different data sets 2
Adding a seperate line to a graph 2
charts won't fully update calculated data 2
Chart Preference grayed out 1
Dates in x axis 1
Excel: secondary Y axes with log-scale X axis 1

Top