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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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,147
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!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,683
Messages
5,838,792
Members
430,569
Latest member
sbardelli

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