Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis

N

Nick_F

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).

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
Axis.

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

Cheers
Nick
 
A

Andy Pope

Hi,

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

Cheers
Andy
 
N

Nick_F

Hi,

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

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

Thanks
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top