I just can't get new data to display on this graph (see below):
I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you see, the first six sets of values are displaying fine.
Why?!
I have the correct cells selected, by the way.
Well, I would've posted an image, but it just won't display, whatever I do.
Ah, it's just one of those days, ain't it...
- Click on graph.
- Right-click and click Select data...
- Make sure the Chart data range covers your data set.
If that doesn't do it, I'll look into something else.
Regards,
GEWB
Generally, to force trend lines to extend farther to right, right click chart and choose select data; then edit horizontal axis labels so they include the new dates.
I've checked the data range, and also tried adding new dates. No joy! Nothing I've tried will convince the thing to display the new numbers. What makes it even weirder is that I have a similar graph on another sheet in the workbook which has over 30 values in it, and it displays everything I enter in it. I can't see any difference between the two!
Quote