I am looking for an answer to a chart problem. On a spreadsheet I have 5columns of numbers. I created a chart and have it put on that sheet as an object instead of as a new sheet. The reason for this is because there is several sheets in the workbook and each sheet has 4 different charts. When I put text boxes or other drawing objects onto my chart and I select the chart to print, my objects disappear or go behind the chart. I just want to select which chart I want and it print a full page chart with my objects. I don't want to set the print area behind the chart and resize the chart to fit the area (unless this is the only answer). If I group the chart and objects as one then select the chart, it still does not print the chart as a full page. I'm confused.
Thanks
Michelle