VBA chart: scale giving strange months

hi

tried to be concise in the the title not sure if it makes sense!

anyway i'll try again.

i have attached a pic to show more clearly, i am outputting charts from vba and they are giving me a problem with the x-axis scale. all the months are fine except when i get to august - 08 it calls it july - 08.

when i hold the cursor over the data point it correctly says aug - 08 point, but on the axis and display it show july - 08, so 2 july - 08's next to each other. i have messed around with the code for hours to try to get it to change and its driving me mad as i have done so many charts and so much code i cant afford the time to go and start again (even though i know this would probably fix it, damn computers!). anyone seen it before or have any ideas on how to fix this?

any help much appreciated.
thanks

steve

The picture isn't much help. Can you post a spreadsheet?

the spreadsheet is a touch large. is this any better? i've left the cursor over the rogue point and you can see it is recognised as aug - 08 but the axis says july - 08.

thanks

Originally Posted by steve@work

the spreadsheet is a touch large. is this any better? i've left the cursor over the rogue point and you can see it is recognised as aug - 08 but the axis says july - 08.

thanks

Hi Steve,

First of all, its very difficult to get the cause because we cannot trace the axis in an image. If you can only embed the chart in a new worksheet and attach it here...it would be really helpful. Or, just double click the X Axes, and paste the screenshot of the Scale...we can give it a try!

Thanks,
Vikas

Originally Posted by vikasbhandari

Hi Steve,

First of all, its very difficult to get the cause because we cannot trace the axis in an image. If you can only embed the chart in a new worksheet and attach it here...it would be really helpful. Or, just double click the X Axes, and paste the screenshot of the Scale...we can give it a try!

Thanks,
Vikas

sorry, cant get the whole file here or just the chart embedded in a new one as its full of stupid vba. i'm by no means an expert so the code is a mess which is probably what is causing it.

i have attached a screenie of the scale tab, i have messed around with this and got rid of the extra july by making max scale equal to 39800 but this messes correlation of the axis with the line up.

i might just get my pencil and paper out in a minute!

thanks for your time.

thanks, changing the cell format helped, glad its wasnt anything drastic!

thanks for your time!

steve