#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 22
Default Excel 2007 option

The display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Excel 2007 option

If your chart is a column chart or a combo chart that includes a column
series, the setting may be disabled. Start with a line chart, change the
setting, then convert the series to the types you need.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DPingger wrote:
The display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 22
Default Excel 2007 option

Thanks for responding, Jon.

Yes it is a line chart, i should have said that earlier, and it's still
grayed out. That's why I'm perflexed. Is there another setting someplace that
I should check?

TIA

dPingger

"Jon Peltier" wrote:

If your chart is a column chart or a combo chart that includes a column
series, the setting may be disabled. Start with a line chart, change the
setting, then convert the series to the types you need.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DPingger wrote:
The display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger

.

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Excel 2007 option

Hmmm, nothing comes to mind.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DPingger wrote:
Thanks for responding, Jon.

Yes it is a line chart, i should have said that earlier, and it's still
grayed out. That's why I'm perflexed. Is there another setting someplace that
I should check?

TIA

dPingger

"Jon Peltier" wrote:

If your chart is a column chart or a combo chart that includes a column
series, the setting may be disabled. Start with a line chart, change the
setting, then convert the series to the types you need.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DPingger wrote:
The display option for charting 0 values is fixed on Zero; the gap option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger

.

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Excel 2007 option

Check to make sure the line chart is not the Stacked Line sub type.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"DPingger" wrote in message
...
Thanks for responding, Jon.

Yes it is a line chart, i should have said that earlier, and it's still
grayed out. That's why I'm perflexed. Is there another setting someplace
that
I should check?

TIA

dPingger

"Jon Peltier" wrote:

If your chart is a column chart or a combo chart that includes a column
series, the setting may be disabled. Start with a line chart, change the
setting, then convert the series to the types you need.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



DPingger wrote:
The display option for charting 0 values is fixed on Zero; the gap
option is
grayed out. How do I get this fixed or is there a step I'm missing?

TIA.


Dpingger

.


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
Excel 2007 - Email Option Rafael S. Excel Discussion (Misc queries) 1 July 23rd 09 07:22 PM
Excel 2007 No Drop Cap option umbrella Excel Discussion (Misc queries) 1 October 31st 07 12:48 PM
Excel 2007 table option DianeG Excel Worksheet Functions 3 July 22nd 07 07:18 PM
Excel 2007 Navigation Option JJ Excel Discussion (Misc queries) 1 April 16th 07 09:01 PM
WHERE IS THE AUTOCORRECT OPTION IN EXCEL 2007? Dewey Excel Discussion (Misc queries) 2 May 27th 06 06:19 PM


All times are GMT +1. The time now is 01:48 PM.

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

About Us

"It's about Microsoft Excel"