# Graphs

#### simonw

##### New Member
I tend to use alot of graphs and use them shorted to show the largest value on the left and therefore the smallest on the right.

Is there any method to automatically alter the range of the graph so zero Y axis values and therefore their corresponding X axis names are not visable on the graph; but will appear as and when data values change.

Regards

Simon

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Assuming that your zero values are y values, and that they are, or can, be expressed as a formula, it isn't too difficult to change the formula do that the zero value will not be plotted. say that your formula is, for cell C2, and copied down:
=A2+B2
Then, just change the formula to:
=IF(A2+B2<>0,A1+B2,#N/A)
and copy down.
You will see that the chart will now totally ignore the values x,y for the point where y=0.

simonw said:
I tend to use alot of graphs and use them shorted to show the largest value on the left and therefore the smallest on the right.

Is there any method to automatically alter the range of the graph so zero Y axis values and therefore their corresponding X axis names are not visable on the graph; but will appear as and when data values change.

Regards

Simon

Depending on the kind of chart you are creating, it may be possible to create a 'hole' -- using the NA() approach you've already been shown. However, it is far from perfect and it does make it obvious where data have been skipped.

An alternative to consider is to create a compact list of all non-zero values. You will have to *adapt* the technique documented by Chip Pearson at http://www.cpearson.com/excel/noblanks.htm

simonw said:
I tend to use alot of graphs and use them shorted to show the largest value on the left and therefore the smallest on the right.

Is there any method to automatically alter the range of the graph so zero Y axis values and therefore their corresponding X axis names are not visable on the graph; but will appear as and when data values change.

Regards

Simon

Replies
1
Views
98
Replies
9
Views
80
Replies
1
Views
276
Replies
7
Views
209
Replies
1
Views
142

1,203,236
Messages
6,054,298
Members
444,715
Latest member
GlitchHawk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back