View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How do I make x-axis dates in area chart not start from/drop to ze

Select the x-axis, and format. Adjust the scale to bring the chart into the
boundaries you want. Note that you'll need to enter a serial number
representing the date you want.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"David Moye" wrote:

When I create an area chart from with a date range as the x-axis, there are
diagonals that take the chart to the data value for the first day, and from
the last data value down to the axis. What I would prefer are verticals as
the diagonals sure make it look like the chart has ended with a 0 y-axis
value, or starts with a 0 y-axis value. Any ideas?