View Single Post
 
Old 06-05-2020, 07:07 AM
Intruder Intruder is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default 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
Attached Files
File Type: xlsx forum graph.xlsx (27.3 KB, 8 views)
Reply With Quote