Hello all
I'm relatively ok with VBA but 100% useless at charts so this may seem obvious to others.
I want my column chart data to change with the value of a drop down.
I've attached a workbook so you can see the data etc.
Also, because some data is formatted as percentages and some as numbers and some as ratios; would it be better to group these into different charts?
Many thanks in advance
Graphs.xlsx
Bookmarks