Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Another Scatter Plot Issue in Excel 2007
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Another Scatter Plot Issue in Excel 2007
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple XY pairs in scatter plot Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Issue | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Freak Out! | Charts and Charting in Excel | |||
Excel Scatter Plot | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |