Hi,
I would like to produce a line chart which on th verital axis has Utilisation and Horizontal is Margin %. In the attached I have drawn a rough image of how I would like it to look but have failed to recreate in the excel charts. The margin increases the lower the utilisation.
I appreciate any help on this.
Many thanks
You need to click on the axies and format options "Values in Reverse Order"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks but that only works on the Virtical Axis I can not get the Horitontal Axis to do what I need. Any ideas
You don't have that option on the horizontal axis? It is there on 2010. I do not currently have 2007 available. I'll ask around
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks