I have a bar graph that is updated each week with statistical information for a number of individuals. However, each week the number of individuals can change from 25 up to 100. I would like to find a way where I can set my source data range and not have to change it every time I update the information for the chart. Can anyone help?
Bar's with a zero value will not be ignored by a chart.
You would need to remove them from the data source. You can do this in 2 ways.
Simplest is to autofilter your data, making sure the chart option to plot visible cells only is enabled.
Construct using formula a data set for the chart that excludes the zero entries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks