Juriemagic
10-27-2015, 03:16 AM
Hi good people,
My sheet contains some data tables on the left, and a chart is on the right. However when we print this sheet, it is desired to have the sheet printed as portrait. so, what I did was make a copy of the chart and placed it underneath the data tables. VBA makes this chart invisible, so looking at the sheet reveals the data on the left and the chart on the right. Printing however, must contain the data tables and the chart underneath. But the chart is invisible. Please could someone assist me in getting this hidden chart to print?. What I preferably do not want, is for the chart to become visible, print, and then go invisible again...is there a way?..all and any help will be greatly appreciated!!. Thank you all kindly!
My sheet contains some data tables on the left, and a chart is on the right. However when we print this sheet, it is desired to have the sheet printed as portrait. so, what I did was make a copy of the chart and placed it underneath the data tables. VBA makes this chart invisible, so looking at the sheet reveals the data on the left and the chart on the right. Printing however, must contain the data tables and the chart underneath. But the chart is invisible. Please could someone assist me in getting this hidden chart to print?. What I preferably do not want, is for the chart to become visible, print, and then go invisible again...is there a way?..all and any help will be greatly appreciated!!. Thank you all kindly!