Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Email Option | Excel Discussion (Misc queries) | |||
Excel 2007 No Drop Cap option | Excel Discussion (Misc queries) | |||
Excel 2007 table option | Excel Worksheet Functions | |||
Excel 2007 Navigation Option | Excel Discussion (Misc queries) | |||
WHERE IS THE AUTOCORRECT OPTION IN EXCEL 2007? | Excel Discussion (Misc queries) |