Help w/ charting three lines in the same chart.
Looking to chart three lines.
1. Inventroy amount (Left)
2. Inventory Utilization % (Right)
3. Inventory Utilization % Target (Right)
So far I've only been able to chart the first two line on separate line charts. If try to combine the two lines on one chart...the Utilization % line will not show. How can we have the utilization line show up on the right side of the chart? thanks for your help.
Frankee
You can not see the % line because the minimum value of the Y axis is not zero.
Format the Y value to be auto.
Select Utilization % line and format. Set to secondary axis.
You would need to add another data series to the chart in order to plot a target line.
It worked Andy...Thanks.
Frankee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks