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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

polizei11

New Member
Joined
Mar 13, 2011
Messages
3
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.
 

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
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?
 

polizei11

New Member
Joined
Mar 13, 2011
Messages
3
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

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
Top