Excel Charting Issue

Question

I track weekly production numbers and am trying to create a chart that only displays up to the current week but updates as data is added. When selecting the source data range, I reference 52 cells formatted as currency that each contain a SUM formula: =SUM(D3,I3,N3,S3,X3,AC3).

The issue is that the chart shows all 52 "weeks". I'm trying to get the charting function to ignore the cells that contain a formula with a SUM formula result of "$ -".

A simple example file (I am using desktop Excel however):

https://docs.google.com/spreadsheets/d/11lBiJPPI3JOAYbwuXJtxLbg4fYizljADmf24vMT1vuM/edit?usp=sharing

Thanks for reviewing.

riny_van_eekelen · Answer

JW_in_MI&nbsp;Transform the data range to an Excel table and base your chart on the table. Add week at the bottom of the table and the chart will expand with every row you add.See attached.&nbsp;

Forum Discussion

Excel Charting Issue

Share

Resources