Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|
Graph to only include rows with data in
Have a look here
http://spreadsheetpage.com/index.php...n_a_line_chart
"Michelle" wrote:
Hello, I want to make a graph which is based on a table which gets its data
from other parts of my spreadsheet - so all the data is made from formulas.
Some of the rows at the bottom will be empty, and I want the graph to ignore
these empty rows, but to include them if data is added at a later date.
Is there a way to point the graph to an area, but to tell the graph to
ignore any rows where the formulas return a blank (or Icould make it zeros
if that helps). I don't want acres of graph with no columns in either, so it
would have to adjust automatically.
I'm OKish with VBA, but I'd prefer a solution that didn't use it if that's
possible.
Thanks
Michelle
|