Charting data - formatting x-axis

[RICKDM]

I am trying to develop a x-y scatter plot for a set of data. I have created the chart. In column S beginning in cell 2, I have the values I want on my x-axis. These values are in the following form: Date_time frame. For instance, S2 contains 6/13/2011 8AM-10AM, S3 contains 6/13/2011 10AM-12PM, S3 contains 6/13/2011 12PM-2PM, S4 contains 6/13/2011 2PM-4PM. S5 starts a new day (6/15/2011 8AM-10AM), and so on. When I try to chart this, the x-axis has numerical values 1,2,3,4 and so on instead of the time stamp. I've formatted the cells in column S to "text". How do I getthe time stamp to show up on the x-axis?

Thanks

 

[Oaktree]

Scatter plots need numerical values on the x axis, but line charts work with text/labels on the x axis.

As such, try using a line chart instead (once it's drawn, you can right click on the series, go to format data series, and select "none" in the line section to hide the line that's connecting the data points).

 

[Steve=True]

For an XY chart, you can also add new data series where the series name=your date/time stamps and the Y=0 X=where you want them. After adding them as unique series, you can add data labels for those unique points and change the label=series name. Remove the original X Axis.

This basically plots a label series at a Zero Height where you want the labels for your xaxis.

This is visual fakeout/substitution for your original xaxis.

Steve=True
www.exceldashboardtemplates.com