Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2020, 07:07 AM
Intruder Intruder is offline Showing data outside Y-axis % range as >100% Windows XP Showing data outside Y-axis % range as >100% Office 2007
Advanced Beginner
Showing data outside Y-axis % range as >100%
 
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, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Showing data outside Y-axis % range as >100% 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft