Chart Copy from one sheet to another?
- Thread starter Taranjeet
- Start date
Why not just move the charts from whatever sheet they are currently on to the dashboard sheet? Or, if the data is actually in cells, I would recommend using the camera link tool.
Luke, thanks for the camera tip.... think i can use that but am having issues with printing.
I have a workbook that has a couple sheets, each sheet with at least 2 pivottables & relating pivotcharts. i used the camera tool to put all the charts (the mirror image/pic) all on one page to make printing easier. I've resized these over and over but it still shows the charts differently than how they print. PrintPreview looks fine, im not even close to my margins.... but when i print it still cuts the right side of my charts off? any ideas?!
I'm right by the Sam Jones Expressway exit, if you wanna swing by!! hahaha
I have a workbook that has a couple sheets, each sheet with at least 2 pivottables & relating pivotcharts. i used the camera tool to put all the charts (the mirror image/pic) all on one page to make printing easier. I've resized these over and over but it still shows the charts differently than how they print. PrintPreview looks fine, im not even close to my margins.... but when i print it still cuts the right side of my charts off? any ideas?!
I'm right by the Sam Jones Expressway exit, if you wanna swing by!! hahaha
Hi Jason,
Taking a long shot, but might be related to this?
http://exceluser.com/blog/1030/still-another-excel-2010-camera-tool-bug-and-how-to-fix-it.html
There are a few bugs that pop up with the camera tool. A more thorough Google search might find something more if you need to.
I might have to take you up on that offer sometime. I'm off of the Illinois st exit on 70.
Taking a long shot, but might be related to this?
http://exceluser.com/blog/1030/still-another-excel-2010-camera-tool-bug-and-how-to-fix-it.html
There are a few bugs that pop up with the camera tool. A more thorough Google search might find something more if you need to.
I might have to take you up on that offer sometime. I'm off of the Illinois st exit on 70.
interesting find, Luke. I'll do some searching
to add to the confusion... i got crafty and added border to all of my cells of the first page and labled the columns so i could see what was getting cut off. #lolgenius
and i found that NO COLUMNS are getting cut off/not printed.... its the display of the charts themselves... while the chart looks great on screen, when i print something changes it and its almost like its printed at a different scale!?! ....weird
anywho, off to googs to search.
LUKE: near downtown?! thought you lived on the westSIIIIDE (lol)?
to add to the confusion... i got crafty and added border to all of my cells of the first page and labled the columns so i could see what was getting cut off. #lolgenius
and i found that NO COLUMNS are getting cut off/not printed.... its the display of the charts themselves... while the chart looks great on screen, when i print something changes it and its almost like its printed at a different scale!?! ....weird
anywho, off to googs to search.
LUKE: near downtown?! thought you lived on the westSIIIIDE (lol)?