Hi all,
I have generated the attached dynamic chart. One issue I have is as follows: the chart picks up the results from column H on the Y-axis which is what I need HOWEVER I need the labels to be against the grade (column G). How can I change the labels to match column G in exchange for the corresponding results in column H?
Thanks for the help.
Re: Y-axis Labels - Dynamic Chart
is this what you are looking for?
Re: Y-axis Labels - Dynamic Chart
no i only needed the numbers on the vertical axis replaced by the corresponding grades
Re: Y-axis Labels - Dynamic Chart
Is this what you're after?
Then you can create a relationship (via formula) between Grade and Results and the labels will be dynamic as well.
Edit: my bad OP, I see what you mean now.
Re: Y-axis Labels - Dynamic Chart
Yes this is exactly what I need. How did you do it? I need to apply this change to other charts in different workbooks. Thanks for the info.
Re: Y-axis Labels - Dynamic Chart
I clicked on each individual data label on your graph and typed "=" (without ""), then clicked on the corresponding grade in the column G. The end result would look something like this =Sheet1!$G$4.
Depending on the amount of graphs/data points you have, there may be a solution already available through VBA to automatically do this with a macro.
Don’t have an account yet? Register yourself now and be a part of our community!
