x-axis values

[Sam Beardsley]

This one's for my 7th grader. He's got events 1-14 in one
column. He's got the value of each of those events in the
next column. All of the values are positive. The first
four values are zero. We're using a bar graph. He
doesn't want the first four zero values to be a part of
the displayed graph i.e. we want the x-axis to begin
at '5'. How do I do this.

TIA, I appreciate you folks being there.
Sam Beardsley

 

[kazz]

Try double clicking on the x-axis of the grapg. Then click
the scale tab on the screen that appears. Uncheck the box
next to minimum and in the box next to the minimum, which
should say 0, type 5. Then click ok to set the x-axis to
start at 5. Hope this works.

 

[Tushar Mehta]

If the two columns do not have a header at the top, add one. Then, use
Data | Filter > Autofilter... to hide the zero values. To do so, once
you have the filter in place, select the drop down for the 2nd column,
then select '(Custom...)' In the resulting dialog box, set the first
drop down on the left to 'does not equal' and corresponding drop down
on the right to '0'

Also, ensure that the chart is configured to only plot visible cells.
Select the chart, then Tools | Options... | Chart tab | ensure 'Plot
visible cells only' is checked.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions