Charts

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
my company publishes articles using pubslisher. We used to use Harvard Graphics to create our charts. However, now are tryong to convert all our charts to excel. the problem we are having is that when we copy and paste a chart to publisher it is very large. when we shrink it to fit the page, it dosen't look right. the fonts cannot be read. I was wondering whether there is a more effecient way of reducing hte size of charts in excel and then exporting or pasting it into publisher document.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Alriemer

Board Regular
Joined
Aug 18, 2002
Messages
102
Try this: make each chart a separate sheet. Go to View and choose Size with Window. Make the file window neither maximized nor minimized by clicking the middle of the three buttons on the right of the title bar. Then you can resize the chart in excel by resizing the window, and force many charts to the same proportions for pasting.
Once saw a macro that let you specifiy a chart size in inches, but don't know how to code.
 

Forum statistics

Threads
1,144,743
Messages
5,726,022
Members
422,653
Latest member
mntsiki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top