Thread
:
Excel Charts - showing parts of a sequence
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
Posts: 4,393
Excel Charts - showing parts of a sequence
You have a time scale axis. To change it:
1 Right click on chart; select Chart options
2 Open the Axes tab
3 For Category X-axis, select Category rather than Automatic or Time-scale
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"How to show interrupted data sequences" <How to show interrupted data
wrote in message
...
I am trying to create an Excel line chart with the X-axis being dates.
Excel
insists on showing every day in the sequence along the axis, and I want to
show only the dates for which I have data. This chart covers one year and
I
don't want 365 date points on the X-axis, only the 59 entries of dates of
significance. Please help~
Reply With Quote
Bernard Liengme
View Public Profile
Find all posts by Bernard Liengme