Excel Bar Chart

[aclare]

Hello,

I am trying to do a stacked chart where I have 7 data points where I am trying to show the total budget number over the total sales. Of the 7 data points, 6 are in the same range of values, and one is about 4 times larger. This last data point is throwing off the scale of my chart so that the other point are harder to read. Is there a way put just one data point on a seondary axis?

Thanks

 

[sdruley]

04.21.2013-07.07.18 - sdruley's library

The above is an example of how sales performance can be tied more effectively to profits. But, the main point in showing this to you is to suggest the use of labels to show budget performance as opposed to charting this as a variable. Rob Bovey's chart labeler is a good product for doing this.