Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart be put in the background in order to display cells?
I would like to put the chart in the "background" such that worksheet cells
and their contents are also displayed and the chart is also visible. Can this be done? If fo, please help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart be put in the background in order to display cells?
Hi,
You can not put the chart behind the cells. What you might be able to do though is make the chart area None so that cells below the chart can be seen through the chart area when the chart is not selected. Or you could just move and size your chart so it does not cover the cells. Cheers Andy 54COCHISE66 wrote: I would like to put the chart in the "background" such that worksheet cells and their contents are also displayed and the chart is also visible. Can this be done? If fo, please help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart be put in the background in order to display cells?
You can put the chart in the background. Create the chart, save the chart as
a graphic image. Choose File, Page Setup, Custom Header, in the left header click the Insert Picture button and find your chart. In effect this is a watermark, which I believe Microsft says can't be done in Excel. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "54COCHISE66" wrote: I would like to put the chart in the "background" such that worksheet cells and their contents are also displayed and the chart is also visible. Can this be done? If fo, please help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart be put in the background in order to display cells
Hello Mr. Pope:
I tried your suggestion and it worked perfectly. Of course, in hindsight, as always, it seems the perfectly logical thing to do. Thanks very much "Andy Pope" wrote: Hi, You can not put the chart behind the cells. What you might be able to do though is make the chart area None so that cells below the chart can be seen through the chart area when the chart is not selected. Or you could just move and size your chart so it does not cover the cells. Cheers Andy 54COCHISE66 wrote: I would like to put the chart in the "background" such that worksheet cells and their contents are also displayed and the chart is also visible. Can this be done? If fo, please help. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can a chart be put in the background in order to display cells
Mr. Devenshi
I tired your suggestion and it does work. However, I prefer to use the solution given my Mr. Pope, the other responder to my question. Thanks for your help. 54COCHISE66. "Shane Devenshire" wrote: You can put the chart in the background. Create the chart, save the chart as a graphic image. Choose File, Page Setup, Custom Header, in the left header click the Insert Picture button and find your chart. In effect this is a watermark, which I believe Microsft says can't be done in Excel. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "54COCHISE66" wrote: I would like to put the chart in the "background" such that worksheet cells and their contents are also displayed and the chart is also visible. Can this be done? If fo, please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Display Order | Charts and Charting in Excel | |||
Display order of Bar Chart | Charts and Charting in Excel | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
Combination chart - area and column - order display? | Charts and Charting in Excel | |||
chart display order | Charts and Charting in Excel |