Chart shows items inbetween dates of dataset

RWayneH
RWayneH used Ask the Experts™
on
Please check the attached file...  how come chart has 7 dates in it and the dataset only has 5?
How do I turn off the adding of dates inbetween dates?
ChartThatAddsDates.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

Dbl-click the axis the select Axis Type Text Axis, you may have to resort your data by the date.

Regards
ChartThatAddsDates-1-V1.xlsx

Author

Commented:
Thanks !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial