Quote:
|
Originally Posted by ToasterIQ2000
Learning curve; like there's the 'add secondary Y axis' in Openofficeorg Calc -- have I just not found that under Excel?
|
On the chart, right click on the chart series you want on the second y axis. select "Format data series" >> "Axis" tab >> select "secondary axis"
Excel is unbelievably capable if you know how to use it. It can be cumbersome if you have a lot of data but I swear by it. I don't know Matlab very well but I am surrounded by people who do and I have yet to see anything done in Matlab that can't be done in Excel. The chart types in Excel are a bit limited though, especially with three or four dimensional problems.