Graphing Blank data

[guacamohle]

I have a table that I update weekly and a bar graph that corresponds with that table. If I select 20 rows of data in which 10 of those rows are blank, I get 10 blank spaces that appear on my bar graph

Is there a way to tell excel not to graph blank data? And to to update the graph as new data is entered?

Also 2nd question, can you link 2 graphs in excel. So when you update a table with data, both graphs are automatically updated. Looking for a different way then selecting extra rows of blank data on graph.

 

[Worf]

Hi

1) To eliminate the spaces, create the chart, then apply auto filter to the source range excluding empty cells.

2) For a dynamic chart,see this page:

Create a Dynamic Chart