I have a variety of tables in excel that sum approx 20 sheets but
occasionally these have a zero value.
The graphs link off these tables and show drops to zero on these occurences.
How do I get the graph to ignore the zero values.

I have seen a sheet in a workbook that just contains buttons to run macro for
graphs.  there we plenty and doubt if they were painstakenly recorded on by
one and then assigned a button.
Can anyone point me in the right direction if its possible to short cut, by

I am working on a spreadsheet comparing the median sold $ to the average sold
$. I want to show this data in a column chart, the primary x axis is price,
the y axis is by month. Since I have 2 values for each month, I want to
display the data on one column per month, with the ...