NatetheGreat
Active Member
- Joined
- Nov 18, 2013
- Messages
- 268
Hello,
I am going to do my best at explaining my needs here.
I have 8 percentage values, all of which represent the percentage of times a value occurs within a certain range on a number line. I want to plot both the number line AND the percentage columns on the same chart. I suspect I may need to plot the number line (single axis line chart) as a transparent 2nd chart on top of the percentage columns chart.
Are there any other suggestions anyone has? Ideally I would prefer to avoid the transparent 2nd chart approach as things do nto line up properly. Ideally I would have everything on one chart so that the percentage bars/columns would be Underneath/Over the part of the number line that they pertain to.
e.g. In a simple case if I have number line of 1-25 and I have 2 column/bar, one of which is product A and is 12% (that is 12% of the time this product falls between 1 and 7) and another column/bar which is Product B and is 66% (that is 66% of the time this product falls between 20-23) then I would want the column/bar for product A underneath the numberline between 1 and 7 and correspondingly the product b column underneath the numberline between 20-23
I don't know if that makes sense. I hope it does. Please help!!!
I am going to do my best at explaining my needs here.
I have 8 percentage values, all of which represent the percentage of times a value occurs within a certain range on a number line. I want to plot both the number line AND the percentage columns on the same chart. I suspect I may need to plot the number line (single axis line chart) as a transparent 2nd chart on top of the percentage columns chart.
Are there any other suggestions anyone has? Ideally I would prefer to avoid the transparent 2nd chart approach as things do nto line up properly. Ideally I would have everything on one chart so that the percentage bars/columns would be Underneath/Over the part of the number line that they pertain to.
e.g. In a simple case if I have number line of 1-25 and I have 2 column/bar, one of which is product A and is 12% (that is 12% of the time this product falls between 1 and 7) and another column/bar which is Product B and is 66% (that is 66% of the time this product falls between 20-23) then I would want the column/bar for product A underneath the numberline between 1 and 7 and correspondingly the product b column underneath the numberline between 20-23
I don't know if that makes sense. I hope it does. Please help!!!