Graphing Blank data

guacamohle

New Member
Joined
Oct 29, 2012
Messages
10
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.
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,010
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top