Hello All,
Here is my situation. I have multi-sheet workbook and each sheet holds a chart (Control cell type holding chart control).
Everything creates great and looks the way I want it. But when I save my workbook to Excel, or as pdf, only visible sheet at the time of saving saves chart as it looks on the screen. All other invisible sheets mess up their charts. I save the chart as the bitmap.
Please check the bitmap I've attached. Inside the attached bitmap, top one is the chart from the visible sheet. Bottom one is from the invisible sheet. Every other invisible sheet does the same.
I'd appreciate somebody let me know if there is a way around this issue. I'm running out of ideas.
Thanks...
chart.zip