I've been copying charts from excel to word docs for years. Suddenly the excel charts got very big, extending off the screen sometimes. And the word docs with even 1 chart are very/too big. EX a 460kb excel workbook with several charts. Copy 1 chart to a blank word doc and the word doc file size may be 440kb.
I've done something wrong or hit a key or ??
Thanks;
joe b.
Really 440kb is too big?? I don't think so
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Yes, too big. Typical word doc size with 1 chart is ~ 35kb.
joe b.
Then try this..
Just copy the chart from excel and in Word press Alt+E+I+S and select different type of formats and check
An excel file of 403kb has much data and several charts. I copied 1 chart to a blank word doc, and the word doc is 461kb. When i click "copy" in excel I get the message "the picture is too large and will be truncated". After copying, Alt e drops down an "undo paste" box, l blacks out/negatives the chart and s makes the chart go away leaving an s only on the word doc.
It seems that excel is making great big charts on its own.
Thanks;
joe b.
I wonder if there are too many temporary files on your system. Maybe Office isn't "cleaning up" after itself as it should.
You could try a clean up utility like Ccleaner from www.piriform.com
Get the FREE version and run it with default settings.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Either there's no free version or it's well hidden.
Any hints?
Thanks;
joe b.
The site has changed a bit but there is still a free version. Go to Piriform and you will see a picture of a house and a listing with Ccleaner. Click on Ccleaner. You will be taken to a page with a large green button labelled DOWNLOAD. (Click on the Mac link if you are running a Mac). The next page will have on the left will have Ccleaner Free. Click on that. Choose the site to download from and click DOWNLOAD...follow the prompts from there.
Proper GOOGLING technique helps here, Google this: CCleaner Free Download
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Once again I can't find the topic I posted here. I cc cleaned and still, went to an excel file of 406kb, copied one chart to an empty word file and the word file is 459kb.
Any hints?
Why does the topic go away?
Thanks;
joe b.
Try pasting the chart as a 'picture' using paste special.
Life's a spreadsheet, Excel!
Say thanks, Click *
Check this also...
- Press F12>>Tools>>Compress Pictures
- Alt+T+O>>Advanced>>Image Size and Quality>>Set Default Target Output to
Thank you both.
Saving as a picture turned size from 456kb to 24 kb.
Going into tools, chart got the excel charts to be small/er again.
Thanks for getting me out of trouble.
joe b.
I keep clicking * and nothing happens. Maybe nothing is supposed to happen.
joe b.
Glad you fixed it and thanks for the feedback
I believe you may be clicking the Star on your own thread lolOriginally Posted by joeb33050
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks