Combined column chart question

[halesowenmum]

Hi

I've been creating a column chart and I know how to include an additional set of data and amend the chart axis type so I can get a line for example.

In terms of the main data in the columns they go from a minimum value of 600 to a max value of 17,000.

I wanted the % variation label (line or whatever) to show the % variation figure between the data in the first and second column, and the % variation figure between the data in the 2nd and 3rd column. The range within these % difference calculations is from -17.1% up to +22%.

What type of chart axis would be the best one for me to use and how do I get it so it's not a flat line hidden at the bottom of the chart (which is what it's doing at the moment) - I need to see the % variance numbers (ideally) sitting displayed between each column.

I'm not sure if the formatting of the vertical axis is what needs tweaking and if so, based on the value ranges given above, what should the max, min etc be? Or do I have to do something else entirely?

Thank you.

 

[XLfriend777]

Hello halesowenmum - What you might try is adding the % diff calculations to the chart as another series. Then you select that series and select Secondary Axis. I just tried it and the default was to add it as a column chart. Then I changed the % diff series to a line chart. That then had the % diff numbers on the right vertical axis and you could have whatever range you wanted. Hope this help.