Hi,
New to the forum and excel in general. I hope someone can help me with this line graph in Excel 2007. I want to create a graph with three vertical axis (on left hand side) that have completely different scales but relate to the horizontal axis on the same scale. If this doesnt make sense I can make it clearer.
Thanks
Jamie Belfast
Last edited by VBA Noob; 11-26-2008 at 02:22 PM. Reason: Marked as solved
Post some data.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Charts only have 2 axis.
In order to create a 3rd you will need to fake the axis using additional data series.
File attached. Load needs to be on the Horizontal and Effort, Efficiency and MA on Vertical Axis. I suppose it doesnt matter if one is on the Left or Right.
Any help will be much appreciated
Jamie
See attached for formula to create new data series.
Data labels are linked to cells.
Andy,
Wow, thanks ever so much, I am very grateful
Jamie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks