View Single Post
 
Old 03-29-2018, 06:10 AM
DBenz DBenz is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default Unable to resize chart created to separate sheet

Hi,
right click on blank area of chart, select move then opt for new sheet, name the sheet, wish to make the chart wider as it features 365 days but right click chart and choose format chart area, select size option and width and height are greyed out.

Instead I size it on same sheet as data, make it full page width, now I can see my data lines.
right click move and move to separate sheet and it becomes full height and a set proportion with large gaps left and right and no longer the required width and my data lines are not visible and wrecked. right click and access size and its greyed out again.

Has Excel a fundamental flaw here as its impossible to size the chart at all on a separate sheet and displaying it on such wrecks the display.

DBenz

Last edited by DBenz; 03-30-2018 at 05:36 AM.
Reply With Quote