A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2007 option



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2009, 04:33 AM posted to microsoft.public.excel.charting
DPingger
external usenet poster
 
Posts: 6
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  
Old November 12th, 2009, 06:11 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
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  
Old November 12th, 2009, 07:50 PM posted to microsoft.public.excel.charting
DPingger
external usenet poster
 
Posts: 6
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  
Old November 13th, 2009, 01:22 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
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  
Old November 13th, 2009, 09:36 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
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

.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:03 PM.


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