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
Excel Charts
-
- Cosmic Lounger
- Posts: 1191
- Joined: 11 Feb 2010, 12:23
- Location: Medway, Kent, UK
Excel Charts
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel Charts
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.
You can customize each of the two axes independently of the other.
See the attached version.
- 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.
You can customize each of the two axes independently of the other.
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- Cosmic Lounger
- Posts: 1191
- Joined: 11 Feb 2010, 12:23
- Location: Medway, Kent, UK
Re: Excel Charts
Brilliant, thanks Hans.
I'll go and have a play.
Regards
Graeme
I'll go and have a play.
Regards
Graeme