![]() |
#1
|
|||
|
|||
![]()
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. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Adeel1 | Word VBA | 2 | 02-27-2017 05:55 AM |
![]() |
Ravin | Excel | 8 | 09-30-2016 06:10 AM |
![]() |
msnarayanan | Excel | 1 | 07-29-2015 06:18 AM |
Creating colour coded columns and auto-generete statistic in separate sheet | krigre | Excel | 1 | 06-10-2015 04:30 AM |
Unable to open PST file, asking for Password, never created one!?!? | Stompandgo | Outlook | 1 | 04-21-2015 12:07 PM |