I have several of these charts with 2-4 series in them.
This could be to compare sales of 2-4 different types of products in the current MTD vs prior MTD
I want to add a series line in between them, but also to add labels that show the % change.
Initially I did this by first adding a series line. Then adding another set of values inbetween with no line, just plotting the % change values on a second axis. The problem with doing this in the stacked columns however is that every time the % changes I have to reorganize the location of the labels to match the corresponding series. Example the 2nd series goes from 10% to 50%. It would then put the label higher then the 3rd and 4th series in the stacked column so I have to move it manually.
I know there is a way to do this, and I think it involved specifiying both x and y values however I couldn't find any instructions on how it was done.
Any ideas?
This could be to compare sales of 2-4 different types of products in the current MTD vs prior MTD
I want to add a series line in between them, but also to add labels that show the % change.
Initially I did this by first adding a series line. Then adding another set of values inbetween with no line, just plotting the % change values on a second axis. The problem with doing this in the stacked columns however is that every time the % changes I have to reorganize the location of the labels to match the corresponding series. Example the 2nd series goes from 10% to 50%. It would then put the label higher then the 3rd and 4th series in the stacked column so I have to move it manually.
I know there is a way to do this, and I think it involved specifiying both x and y values however I couldn't find any instructions on how it was done.
Any ideas?
