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