Hi everyone,
I need to create a bar graph that shows two value labels, one for volume and another for %. The problem is that the two value labels overlap when the volume is low. So I decided to remove the % value labels completely, and source the % data column into the x-axis, so it shows the category name and then the % value next to it.
(If someone knows a good way to solve the problem by just aligning the two value labels a certain way, that's even better)
The issue I'm running into in simply sourcing the % values into the x-axis is that, the raw data cannot be altered, and in between the category name column and the % data column, there are 2 columns of information (volume, average). When I tried to source the category column (i.e. $A$1:$A$17,$D$1:$D$17) it doesn't show column D (which is %) in the x-axis. When I source ($A$1:$D$17) it shows the values, but the problem is, it shows volume, average, then %, I need the graph x-axis to only show category name + %.
