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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|