View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
cdwinlib cdwinlib is offline
external usenet poster
 
Posts: 1
Default data series and axis labels

I will try my best to ask this question in a way that makes sense-

I have a line chart showing monthly sales. My X axis is labeled Jan - Dec
and my data series is the sales by month. I have figures for Jan Feb Mar and
Apr but since May - Dec are at $0 my chart currently shows a straight line
down from Apr to May.

Is it possible to stop the line at April yet keep the axis showing Jan - Dec?

Thanks!