Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
In Office 2003, I used to be able to select the following when formating a
data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
Hi,
Are you sure about that selection in 2003. For a column chart the option of a Shadow is available on the Patterns tab. The Fill Effects button displays a dialog with Gradient, Texture, Pattern and Picture. But these are all fill effects and not shadows. Any way in xl2007 you would select the series and then using Chart Tools Format Shape Styles Shape Effects Shadow You now have a host of shadow effects which can be applied. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
Andy,
You are correct, it does not say shadows, it says fill | effect | shading. This would give me shading on the left and right sides. Can that be done in Office 2007? "Andy Pope" wrote: Hi, Are you sure about that selection in 2003. For a column chart the option of a Shadow is available on the Patterns tab. The Fill Effects button displays a dialog with Gradient, Texture, Pattern and Picture. But these are all fill effects and not shadows. Any way in xl2007 you would select the series and then using Chart Tools Format Shape Styles Shape Effects Shadow You now have a host of shadow effects which can be applied. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
select the series and then using Chart Tools Format Shape Styles Shape
Fill Gradient Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... Andy, You are correct, it does not say shadows, it says fill | effect | shading. This would give me shading on the left and right sides. Can that be done in Office 2007? "Andy Pope" wrote: Hi, Are you sure about that selection in 2003. For a column chart the option of a Shadow is available on the Patterns tab. The Fill Effects button displays a dialog with Gradient, Texture, Pattern and Picture. But these are all fill effects and not shadows. Any way in xl2007 you would select the series and then using Chart Tools Format Shape Styles Shape Effects Shadow You now have a host of shadow effects which can be applied. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
Thanks Andy. The selection missing here that was in Office 2003 is the
equivalent of linear left and lineat rigth combined. Thanks for all of your help. "Andy Pope" wrote: select the series and then using Chart Tools Format Shape Styles Shape Fill Gradient Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... Andy, You are correct, it does not say shadows, it says fill | effect | shading. This would give me shading on the left and right sides. Can that be done in Office 2007? "Andy Pope" wrote: Hi, Are you sure about that selection in 2003. For a column chart the option of a Shadow is available on the Patterns tab. The Fill Effects button displays a dialog with Gradient, Texture, Pattern and Picture. But these are all fill effects and not shadows. Any way in xl2007 you would select the series and then using Chart Tools Format Shape Styles Shape Effects Shadow You now have a host of shadow effects which can be applied. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Graph Functionality
Andy,
I found it. I needed to go one more step past what you said to Direction. That gives me the left and right shading on the graph series that I was missing. "Andy Pope" wrote: select the series and then using Chart Tools Format Shape Styles Shape Fill Gradient Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... Andy, You are correct, it does not say shadows, it says fill | effect | shading. This would give me shading on the left and right sides. Can that be done in Office 2007? "Andy Pope" wrote: Hi, Are you sure about that selection in 2003. For a column chart the option of a Shadow is available on the Patterns tab. The Fill Effects button displays a dialog with Gradient, Texture, Pattern and Picture. But these are all fill effects and not shadows. Any way in xl2007 you would select the series and then using Chart Tools Format Shape Styles Shape Effects Shadow You now have a host of shadow effects which can be applied. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dturpin1" wrote in message ... In Office 2003, I used to be able to select the following when formating a data series in a graph: fill effects | shadows This would basically give me shadows on the left/rigt sides, etc. This does not appear to be available in Office 2007. Can I still make this selection? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph in Excel has one data label missing | Charts and Charting in Excel | |||
missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
I can't get my graph to interpolate my missing data | Excel Discussion (Misc queries) | |||
Missing Graphing Functionality | Excel Discussion (Misc queries) | |||
ignore missing values while ploting graph | Excel Discussion (Misc queries) |