Excel Graph help

[Takes2ToTango]

Hi all,

I am creating a graph that shows data over a two-year period. I have created a list of months coinciding with dates, as seen below. I then used these months to populate the X-Axis. However, for some reason, some months get duplicated while some don't. For the life of me, I cannot see why this is so. The 'Date Axis' and 'Bounds' does not appear either.

 

[RoryA]

What is the axis interval set to? Your values are text, not dates, which is why you don't have date axis options available.

 

[Takes2ToTango]

What is the axis interval set to? Your values are text, not dates, which is why you don't have date axis options available.

Axis interval is set to 1. I have tried changing this but it seems to remove the ones that are not duplicated.

 

[RoryA]

Sorry, I meant the label interval.

 

[Takes2ToTango]

Sorry, I meant the label interval.

Label interval also set to 1. Does this need to be manipulated?

 

[RoryA]

I don't see how that can be since it is clearly not showing every label. Is the 1 option actually selected or is it set to automatic?

 

[Takes2ToTango]

I don't see how that can be since it is clearly not showing every label. Is the 1 option actually selected or is it set to automatic?

Ah sorry it was set to automatic! I stupidly looked at the number and not the check box. It is set to 1 so I have played around and changed it, howeverit is doing the same with removing the months with no duplicates. Is there an easier way to set it up so that I can have 'mmm/yyyy' displayed along the x axis which also changes when the data does?

 

[RoryA]

You could use the actual dates for the axis values, and simply format the axis using a mmm-yyyy custom number format. Then you will have date grouping options such as showing ticks every month

 

[Takes2ToTango]

You could use the actual dates for the axis values, and simply format the axis using a mmm-yyyy custom number format. Then you will have date grouping options such as showing ticks every month

Thank you! Works great. I knew there would be an easier solution than what I was trying!

 

[RoryA]

Glad we could help.