Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 09, 09:14 AM posted to microsoft.public.excel.charting
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 on ahorizontal date axis

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

  #2   Report Post  
Old May 20th 09, 09:46 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Excel 2007: Line where a gap should be, but only when plotting on a horizontal date axis

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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).

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


  #3   Report Post  
Old May 20th 09, 01:39 PM posted to microsoft.public.excel.charting
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:
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

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"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.

Thanks
Nick

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart - time series - category axis date format (2007 VBA) Paul Jacob Charts and Charting in Excel 1 April 18th 09 03:10 AM
Plotting Date and Time on the same chart axis mccredda Charts and Charting in Excel 1 February 19th 09 05:11 PM
Excel 2007 line chart automatic category axis text rotation Boris Charts and Charting in Excel 2 December 4th 08 11:56 PM
Line chart categoray axis labels issue - Excel 2007 Boris Charts and Charting in Excel 2 December 4th 08 04:55 PM
Line and a Col on 2 axis in Office Excel 2007 jake the peg Excel Discussion (Misc queries) 2 January 31st 08 08:12 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017