How do I hide part of a data series in a chart?

J

Jeff Bremer

We have a chart with 2 data series - Budget & Actual. We want to show all 12
months of the budget, but only the year-to-date months of the actual. The
problem is the data cells for the future actual amounts have formulas in them
so the chart use the result and plots the line. We do not want to delete the
data (which will require manual input each month, we just want the actual
data series line to not show for the future periods. We tried using IF
statements with 0, "", " " and an alpha character, but these have not worked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 5
Convert Error Bars to Series and Colour 1
starting a data series in the middle of a chart 2
Not plot a data series in a chart but still display in data table 1
Hide bank series in Data Table 0
2 colors in one line 2
Assign data series to primary axis 1
Variable series multi line chart? 1

Top