Excel Charts

User avatar
Graeme
Cosmic Lounger
Posts: 1191
Joined: 11 Feb 2010, 12:23
Location: Medway, Kent, UK

Excel Charts

Post by Graeme »

I bought an Arduino to play with. (A man has to have a hobby!) The kit comes with an humidity, temperature sensor. And I have used the excellent ArduSpreadsheet Arduino plugin by Indrek Luuk to output the Serial Monitor to a CSV file. Then I saved the CSV as an Excel spreadsheet and made a chart to display the data. I've got Date and Time on the X axis with Humidity % and Temperature °C on the Y axis.

Is it possible to have two scales on the Y axis, either both on the left or one on either side, so that the Humidity data and the Temperature data don't have to share the same scale? I'm looking to stretch the Temperature and the Humidity data more over the Y axis.

Please see attached. The jump in Humidity was caused by me blowing on the sensor!

Regards

Graeme
You do not have the required permissions to view the files attached to this post.
_______________________________________

http://www.averywayobservatory.co.uk/

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Charts

Post by HansV »

Yes:
- Click on one of the two series in the chart to select it.
- Activate the Format tab of the ribbon, next to the Chart Design tab.
- In the Current Selection group, click Format Selection.
- Under Series Options, select Secondary Axis.

S1802.png

You can customize each of the two axes independently of the other.
See the attached version.

Results_log_01.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
Graeme
Cosmic Lounger
Posts: 1191
Joined: 11 Feb 2010, 12:23
Location: Medway, Kent, UK

Re: Excel Charts

Post by Graeme »

Brilliant, thanks Hans.

I'll go and have a play.

Regards

Graeme
_______________________________________

http://www.averywayobservatory.co.uk/