Hiding 0 value data points on line graph

**brendangroff** · 01-14-2016, 04:00 PM

Is there a way to hide data points that equal 0 on a line graph? I know there is a way to hide blank fields, but I have monthly data for the upcoming year that is 0 for months in the future.

So for instance: currently there is only January data (cell A16), so that data point I want shown on the graph, but February-December (cells B16:L16) are zero so I do not want them shown on the graph. I do not want to clear them because when data does hit for these months/cells I Want them automatically added to the graph. Is this a possibility?

THANKS!

**teylyn** · 01-14-2016, 04:28 PM

Hello,

if you have a formula in the cells, let the formula return a NA() instead of a zero value when there is no data yet for that month.

If you only want to show the months with data in the chart, so the X axis only shows February once there is data for that month, you need to look into dynamic charts that include the data points as the data is added. Jon Peltier has a tutorial here.

cheers, teylyn

Hiding 0 value data points on line graph

LinkBack

Thread Tools

Rate This Thread

Display

Hiding 0 value data points on line graph

Re: Hiding 0 value data points on line graph

Thread Information

Users Browsing this Thread

Similar Threads

excel graph - select data points on line graph and return its corresponding vaue

[SOLVED] Bar & Line graph for 30 day rolling data points

Need help drawing a line that fits three points on a graph

Problem charing w/line graph when a series has missing data points

Naming specific data points in line graph

[SOLVED] Need 2 rows to display X axis data points for a line graph

[SOLVED] missing data points causes my line graph not to connect

Bookmarks

Bookmarks

Posting Permissions