Printing multiple worksheets with charts

Bean Dinner

New Member
Joined
Aug 10, 2014
Messages
3
I have a weird problem printing multiple worksheets, all of which contain charts only. If I try to print all the pages at once by selecting all 10 worksheets (21 pages total), they seem to get broken up into batches. I can't see any logic to it. This happens no matter which printer I am using, or even if I print to a PDF program. If I print to PDF, I get several prompts to save the files individually - some may have 4 pages, some 2, some more.
If I print to a printer and change the properties so that it prints them in color, it will only print one set in color and then revert to the default B&W. So the first pages will be color, and then the rest will be B&W.
What is going on? I've tried to get answers to this before, with no luck. Surely I'm not the only person in the world this happens to?
Thanks for any light you can shed on this issue.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,215,438
Messages
6,124,873
Members
449,192
Latest member
MoonDancer

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
Back
Top