Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I want to plot a graph based on a river and its velocities. with the velocities above the x-axis and the depths below.
Dead easy to get it to look right but i can't think of a way to get the units etc to be different above and below the x-axis
I can and have already done it by hand but it would be conveneient and look neater if i could generate it.
Put one series on a second y axis? Not sure if that would work as you want.
Excel plotting tools are pretty poor once you get past a basic bar chart.
Time to learn python or R...
Do a search for Excel secondary axis and the version of Excel you're using.
yeah, I understand the secondary axis its just not quite what I am looking for.
its essentially two charts seperated by the x axis. If the numbers were wildly different it would make more sense but the secondary axis isn't going to make anything more obvious.
I find them less than intuitive once you get past eh wizard and find it isn't displayed as you planned - have an online training course queued up when I have time.
OP out of interest isthe river velocity stuff that part of your job or study? I did my thesis on river velocity/sediment size/invertebrate diversity. Happy days with the Rivers Authority (I'm that old) V8 landy using my card to access river banks around the cotswolds.
Is this any good?
rescale one of the datasets to get them to about the same order then.
or use something more controllable than excel...
pedlad
Job and Study, I get a crappy astra van and don't need keys as its scotland and actually i spend quite alot of time indoors 😀
It's not a big deal just thought it wasn't that taxing a concept for the wizard to just do it.
You get a lot more flexibility drawing graphs in Excel using VBA, I find it easier to get what I want and a lot quicker if I am plotting lots of traces on one graph.
I understand the secondary axis its just not quite what I am looking for
Hmmm - so I don't really understand what you are looking for - I was assuming one chart has -ve Y values and the other positive, so don't follow why a secondary axis isn't the answer...
its essentially two charts seperated by the x axis
but in that case just create two charts, scale the X axes the same and place them one above the other?
Do two seperate charts, to the same scales / increments / dimensions.
Make one have transparent background and drag it over the top of the other. Hide / remove any chart elements that clash.
Bosh.