Line chart does not show all datapoints

[gsamborn]

Hi

I have a line chart that shows the number of pain-killers (0-7) by date (Mar-20 to Sep-15). Everything worked fine until Aug-1.

I have checked the data range (c2:c181) and the range for labels (a2:a181) but no matter what I do, the chart only shows values for Mar-20 to Aug-1 (135 datapoints).

When I select data it shows the following which is correct: =Table!$A$2:$A$181,Table!$C$2:$C$181

The data shown on the chart appears to be: =Table!$A$2:$A$136,Table!$C$2:$C$136

I've tried reselecting the data and creating a new chart from scratch, only to produce the same results.

Any suggestions?

Thanks.

[BadlySpelledBuoy]

Right click on the dates on the X axis then select "Format Axis".
Where it says "Axis Options" you have the maximum set to a defined date. Set that to "Auto", et voila!

BSB

[gsamborn]

I knew it must've been something easy.

Thanks a lot!

[BadlySpelledBuoy]

Only easy when you know where to look

Happy to help.

BSB