X Axis Date Scaling

polizei11

New Member
Joined
Mar 13, 2011
Messages
3
I have a created a chart with an x axis to show dates. I have values that have an x value of the 15th (mid-month) of each month from July 2008 to December 2010. The x axis of my chart shows a range from June 2008 to February 2011 with ticks at random equidistant intervals.

Is there a way to show only the actual x values of my data?


For reference:

Excel 2007
Chart Type: XY Scatter
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
I wasn't able to get the scrolling chart idea to work. I feel like there is a simple way to do this that I just can't figure out.
 
Upvote 0
I wasn't able to get the scrolling chart idea to work. I feel like there is a simple way to do this that I just can't figure out.

Sorry, not so sure what a simplier way means. Did you take a look at the demo on the link provided?

Based off of the sample demo, How does it not work for you? What do you desire?

Any way you can upload a sample workbook to a site like Box.net?
 
Upvote 0
I was able to adjust the scale that excel chose. It seems the default was in days so I made the major unit 31 days and it came close enough to my chosen values. Thanks for the help!
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top