Another Scatter Plot Issue in Excel 2007

J

jeffch1970

I have a tenure list in the form of days. My numbers go from 1 to
1296. I have to plot just these numbers on an XY Chart with Time as X
and the actual number in days as Y. When I try to do this, Excel gives
me the data with Time as Y and Actual Number as X. This is not what
the bosses want. Also, is there a way to format my Y axis assuming I
can get the actual number there, to be delineated in increments of 30.
I've tried to format it, but can't seem to make it happen. Any help
would be appreciated.
 
J

Jon Peltier

Put the X values into a column to the left of the Y values. If you've
already made the chart, go to Chart menu > Source Date > Series tab, select
the series, and switch the contents of the boxes for X values and Y values.

- Jon
 

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

Non Linear Scatter plot, need to find y value 3
Scatter chart with categories on x-Axis 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Charting scientific data - Excel 2003 5
Timeline Plots 0
Scatter plot 1
problem with scatter diagram excel 2007 2
XY scatter plot with more than 32000 rows in Excel 2003 0

Top