View Single Post
  #3   Report Post  
Old May 20th 09, 01:39 PM posted to microsoft.public.excel.charting
Nick_F Nick_F is offline
external usenet poster
First recorded activity by ExcelBanter: May 2009
Posts: 17
Default Excel 2007: Line where a gap should be, but only when plotting ona horizontal date axis

On May 20, 4:46*pm, "Andy Pope" wrote:

With SP2 applied I do not see the behaviour you are describing. I get gaps,
for empty cells, with both Date and Text axis.



Andy Pope, Microsoft MVP - Excel"Nick_F" wrote in message


I have a series of weekly values that I am trying to plot. For some
weeks there is no data is present and the cells are empty (no formula
results or anything).

New computer, first time on excel 2007, same headaches! The SP2
install cured this one.


When I plot the data and set the horizontal axis option to 'Date Axis'
Excel plots a line through the missing data, where I want gaps. I have
set the option for Excel to leave a gap (under Select Data Empty and
Hidden Cells) in the plot but it is ignoring the setting.

If I set the axis to 'Text Axis' it plots the line with gaps but I
lose the benefits that come with setting the horizontal axis as a Date

Any ideas on how I can have excel plot with gaps when using a date