Overlayed Stacked Bar Charts

[rywillc]

G'day All,

Wondering if someone might be able to give me a hand with an charting issue. 2 years ago I built a sheet which used clustered bar graphs and overlaid 2 series over each other to create a time line showing when in certain activity occurred (Image 1 & 2). The only problem is now when I try and recreate instead of charting the same series its charting them in a gnat style chart (Image 3). Image 1.JPGImage 2.JPGImage 3.JPG

Thanks in advance!

[Pepe Le Mokko]

Administrative Note:

Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "Home" ( country will suffice, no need to be more precise).
Thank you for helping us to help you

[rywillc]

Sorry about that mate, ive updated the profile.

[Andy Pope]

If you add the vertical axis to the chart that is working you can then compare the 2 vertical axes and ensure the new one matches the old one.

Also check all of the series as not all have the range defined for category labels.

[rywillc]

Thanks Andy,

Knew it would be something simple, Fixed up the axis, then adjusted the Format Ais>Axis Options>Axis Type to Date axis and its working now.

Thanks for your hand mate