Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Camera in Excel 2007
Dear Group,
who knows the following effect: Using Excel 2007 SP1 with Windows XP SP2, Excel cameras which show charts are blank after opening the workbook. After working a while, or doubleclicking the cams several times, the cameras suddenly refresh. I could also observe that charts haven't refreshed after changing a value. Calculation is set to Auto. I can reproduce this on two different computers (XP). Does XL2007 work better with Vista? Thanks in advance, Holger. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Camera in Excel 2007
Are you using the camera to simply make a copy of the chart? Why not just
make a copy of the chart, and put it where the camera object is? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... Dear Group, who knows the following effect: Using Excel 2007 SP1 with Windows XP SP2, Excel cameras which show charts are blank after opening the workbook. After working a while, or doubleclicking the cams several times, the cameras suddenly refresh. I could also observe that charts haven't refreshed after changing a value. Calculation is set to Auto. I can reproduce this on two different computers (XP). Does XL2007 work better with Vista? Thanks in advance, Holger. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Camera in Excel 2007
I'm doing this with different intentions:
- rotating column charts to get bar charts because of known difficulties with bars and XY (scatter), - switching different charts with conditional excel-names, - adjusting charts with excel-names behind the camera that use =offset() in combination with 1 pixel-size columns and rows and - simply copy and stack charts to be able to reach each single chart easily This is an example. http://itbuero.gerths.de/download/DeviationBars.xlsx Here, the first two stacked cameras are shown immediately and the other two not. Holger. "Jon Peltier" schrieb im Newsbeitrag ... Are you using the camera to simply make a copy of the chart? Why not just make a copy of the chart, and put it where the camera object is? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... Dear Group, who knows the following effect: Using Excel 2007 SP1 with Windows XP SP2, Excel cameras which show charts are blank after opening the workbook. After working a while, or doubleclicking the cams several times, the cameras suddenly refresh. I could also observe that charts haven't refreshed after changing a value. Calculation is set to Auto. I can reproduce this on two different computers (XP). Does XL2007 work better with Vista? Thanks in advance, Holger. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Camera in Excel 2007
Ah, so you really need the camera objects.
I have heard of issues with camera object in 2007, but I use these objects rarely, so I don't recall details. In at least one case, a problem with camera objects went away after the user installed a printer driver. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... I'm doing this with different intentions: - rotating column charts to get bar charts because of known difficulties with bars and XY (scatter), - switching different charts with conditional excel-names, - adjusting charts with excel-names behind the camera that use =offset() in combination with 1 pixel-size columns and rows and - simply copy and stack charts to be able to reach each single chart easily This is an example. http://itbuero.gerths.de/download/DeviationBars.xlsx Here, the first two stacked cameras are shown immediately and the other two not. Holger. "Jon Peltier" schrieb im Newsbeitrag ... Are you using the camera to simply make a copy of the chart? Why not just make a copy of the chart, and put it where the camera object is? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... Dear Group, who knows the following effect: Using Excel 2007 SP1 with Windows XP SP2, Excel cameras which show charts are blank after opening the workbook. After working a while, or doubleclicking the cams several times, the cameras suddenly refresh. I could also observe that charts haven't refreshed after changing a value. Calculation is set to Auto. I can reproduce this on two different computers (XP). Does XL2007 work better with Vista? Thanks in advance, Holger. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Camera in Excel 2007
I have installed several printer drivers and I have tried out all of a them
as default printer, but this has not changed anything. Could you imagine that this effect would change when using Vista instead of XP? I opened the xlsx as zip and found the cameras in xl\media as emf-files. There I can see that the cams are sometimes empty. Thanks, Holger. "Jon Peltier" schrieb im Newsbeitrag ... Ah, so you really need the camera objects. I have heard of issues with camera object in 2007, but I use these objects rarely, so I don't recall details. In at least one case, a problem with camera objects went away after the user installed a printer driver. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... I'm doing this with different intentions: - rotating column charts to get bar charts because of known difficulties with bars and XY (scatter), - switching different charts with conditional excel-names, - adjusting charts with excel-names behind the camera that use =offset() in combination with 1 pixel-size columns and rows and - simply copy and stack charts to be able to reach each single chart easily This is an example. http://itbuero.gerths.de/download/DeviationBars.xlsx Here, the first two stacked cameras are shown immediately and the other two not. Holger. "Jon Peltier" schrieb im Newsbeitrag ... Are you using the camera to simply make a copy of the chart? Why not just make a copy of the chart, and put it where the camera object is? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... Dear Group, who knows the following effect: Using Excel 2007 SP1 with Windows XP SP2, Excel cameras which show charts are blank after opening the workbook. After working a while, or doubleclicking the cams several times, the cameras suddenly refresh. I could also observe that charts haven't refreshed after changing a value. Calculation is set to Auto. I can reproduce this on two different computers (XP). Does XL2007 work better with Vista? Thanks in advance, Holger. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Camera tool & Excel 2007 | Excel Discussion (Misc queries) | |||
Camera bug in 2007? | Excel Discussion (Misc queries) | |||
Camera feature in Excel 2007? | Excel Discussion (Misc queries) | |||
insert picture excel 2007 from scanner or camera | Excel Worksheet Functions | |||
I am trying to use the "Camera" function within Excel | Excel Worksheet Functions |