Hi all,
I have created a combination chart in excel - my bar chart covers 3 years and I'd like to show the growth rate as a line chart on top of those. Is there a way to limit the line chart to just the outer two years? When I alter the data selection to only include the growth rate for 2 of the 3 years, the line chart ends up on top of the two left-most bars instead of the two right-most bars. Any ideas?
Thanks!
I have created a combination chart in excel - my bar chart covers 3 years and I'd like to show the growth rate as a line chart on top of those. Is there a way to limit the line chart to just the outer two years? When I alter the data selection to only include the growth rate for 2 of the 3 years, the line chart ends up on top of the two left-most bars instead of the two right-most bars. Any ideas?
Thanks!