BostKlem
New Member
Hi
I'd like to get your help on this ...
I have a table with the data per quarter and I created a stacked bar chart with that data.
Now, I'd like to add another bar next to those stacked bars that will show YTD (year-to-date) data.
I tried doing it with secondary axis but all I could do is use a line.
Is there a way to do what I want? If so, I'm eager to learn it.
I'm attaching a file with the table and the proposed chart - I put my expectation in a blue bar.
The second question I have relates to the scales of primary and secondary axis - is there a way to "lock" them so that when the primary changes, the secondary changes, too?
Thanks,
Bostjan
I'd like to get your help on this ...
I have a table with the data per quarter and I created a stacked bar chart with that data.
Now, I'd like to add another bar next to those stacked bars that will show YTD (year-to-date) data.
I tried doing it with secondary axis but all I could do is use a line.
Is there a way to do what I want? If so, I'm eager to learn it.
I'm attaching a file with the table and the proposed chart - I put my expectation in a blue bar.
The second question I have relates to the scales of primary and secondary axis - is there a way to "lock" them so that when the primary changes, the secondary changes, too?
Thanks,
Bostjan