#1
|
|||
|
|||
Showing data outside Y-axis % range as >100%
Hi
I have a small dataset showing 7 series with 1/ total amount (shown as vertical bars), 2/ assigned amount (shown as labeled hyphen dots) 3/ % used (shown as labeled diamant dots, total vs assigned). 1 and 2 refers to prim Y-axis, % to secun Y-axis. Some series extend 100% used as totals are far above assigned amounts and as such are not shown on % Y-axis. 2 graphs are shown, 1 with red squares around series of interest and 1 with how i woulk like to be shown. Anyone to solve? thanks in advance |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change displayed y-axis range? | LisaP | Excel | 2 | 11-01-2019 05:03 AM |
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump | jcyo233 | Excel | 6 | 10-18-2018 04:49 AM |
X axis does not show Years from data | MARENG | Excel | 8 | 01-20-2015 10:45 AM |
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 | sharath_ms | PowerPoint | 0 | 07-08-2013 10:06 PM |
how do I add data values in Col A into X axis on bar graph? | hazz | Excel | 1 | 04-27-2010 01:42 PM |