Excel Graph problem

to Kees suggestion is to experiment with different graph types.

Do you have to have a line graph? What about an Area graph where the area underneath the line is filled in with a color or pattern. Then at the date of the latest data, the area just stops in a vertical line, and does not look strange at all.

Or could you use a Column graph? Any empty columns would show up as very thin zero amount lines on the X axis.

If neither of those suit you, (and they are not always the right kind), then Kees suggestions seems the best way.

Mark

The problem with this is that there are several lines on each graph, and it might look a bit too confusing with multiple columns.

I think I may have to go down the macro route.

The other solution, which I am trying to avoid, because it's a bit tricky to set up, is to build a pivot table out of your data, and graph that.

You can have a column in the data to flag if data exists for that week, and have the pivot table ignore unflagged lines.

Then all you have to do is update the pivot table each week.

with the macro. Or the Pivot Table.

I have always struggled with Pivot Tables and I must get round to sorting myself out with them.

Mark