Using Excel 2007
I have a Bar Graph
As I try to shrink the chart from right to left the end of the data bar moves proportionately away from the right edge of the plot area and the chart area
I would simply like to decrease both the chart area and plot area so they are snug to the right end of the longest bar. This way, no wasted space.
I will then copy the chart, paste and update the datsource to the new set
I am a bit concerned with this strategy as it may lead users to draw incorrect conclusions of the dash as the values may have large swings
I thought about solving this with data labels at right end of the bars, but some values may become so small that the value label dangles in thin air
How do you suggest to handle these issues?
Can you point me to some good samples?