Excel Chart Help

Pthree

NeilF3485 wrote: »

Do you mean the marker points have moved from the left to the right of each date, the legend has moved, the Y axis has switched sides, or that all of the data now doesn't align with the dates?

Or something completely different?

Would suggest just doing select data and reselecting both data, and axis labels as a starting point!

The Y axis have moved from left to right, reselecting seems to take me back to square one with no March showing

Stompa

NeilF3485 wrote: »

Doing that still defaults to the 1st on mine? Very strange.

Only way that mine fixes is by switching to text labels, which doesn't impact on anything else either.

Excel 2010 btw.

I'm using Excel 97, perhaps they fixed/broke it in a subsequent release!

NeilF3485

Pthree wrote: »

The Y axis have moved from left to right, reselecting seems to take me back to square one with no March showing

Have you accidentally selected to "plot on secondary axis"? (thought you needed more than one data series to do this though)

If reselecting has put you back to square one, have you then redone the text labelling on the axis - did this switch the axis again?

In all honesty, I would probably just build the graph again from scratch, and then reselect the text format for the axis.

I built a very basic version in order to answer the questions and mine seems spot on.

NeilF3485

Stompa wrote: »

I'm using Excel 97, perhaps they fixed/broke it in a subsequent release!

Sounds very much like something Microsoft would do!

NeilF3485

Just one more thing!! (I feel like Columbo!)

Did you accidentally change the "Vertical Axis Crosses" to "At Maximum Category" when editing the X Axis?

This would have the exact same impact - check that it is set to "automatic"

Stompa

NeilF3485 wrote: »

Sounds very much like something Microsoft would do!

Indeed.

After a bit of experimentation it seems it only works if dd in the initial value is 31. So if your initial date happens to be 30/06/2008 then all subseqent dates are shown as 30/mm/yyyy, except for February which is shown as 28 or 29. So each dd shown appears to be Min(initial dd, days in that month). I guess that makes some sort of sense.

Pthree

NeilF3485 wrote: »

One more thing!!

Did you accidentally change the "Vertical Axis Crosses" to "At Maximum Category" when editing the X Axis?

This would have the exact same impact - check that it is set to "automatic"

I didn't do that, honest!!! It somehow did it itself lol

I'm running 2007 and I swear my version is haunted, things that are perfect just seem to go all over the shop for no reason!

Thank you both for your help, I think I am all sorted now :T:T:T

NeilF3485

Pthree wrote: »

I didn't do that, honest!!! It somehow did it itself lol

I'm running 2007 and I swear my version is haunted, things that are perfect just seem to go all over the shop for no reason!

Thank you both for your help, I think I am all sorted now :T:T:T

Woohoo!!

I was starting to get concerned that I would spend all day playing with this rather than doing my job There is no way I would have been able to let this go!

NeilF3485

Stompa wrote: »

Indeed.

After a bit of experimentation it seems it only works if dd in the initial value is 31. So if your initial date happens to be 30/06/2008 then all subseqent dates are shown as 30/mm/yyyy, except for February which is shown as 28 or 29. So each dd shown appears to be Min(initial dd, days in that month). I guess that makes some sort of sense.

I can't get that to work at all, I started with initial date as 31 and it still won't do it.

Only way mine works is to have text labels instead of auto/date. Any other settings show as the 1st.

Oh well, I imagine it'd work just fine if I tried it tomorrow!

Stompa

Not sure if post#7 here:

http://www.mrexcel.com/forum/showthread.php?t=571020

adds anything useful.