Line Chart

[doylzer]

hey all,

I have been trying to make a table (attached)
I have turnover figures and update this on a weekly base, but every week i have to re-select the data so that the graph looks good.

I want the graph to automatically update to the new figures as the weeks pass but not to display the zero.
Can you please help.

[duffry]

If you replace the zero with NA() it will not draw the line.

If you don't want to show the NA()'s then it might be worth having a helper table you draw from and something like:

Please Login or Register  to view this content.

[EDIT] Example:
Book2b.xlsx