View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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~