Forum Discussion
Excel graph question (number & date)
Hi all,
I feel quite silly for not being able to figure this out. We queried some data using a plugin in Excel, to display resource consumption in our factories. In this example we're looking at the water consumption as measured by sensors across a 20 minute period:
The consumption total column is formatted as "number, 9 decimals" and the Timestamp column has been formatted as "Time, hh:mm:ss" but tried custom as well.
Over this period I'd like to make a super simple Excel graph, a line going up showing you when we used what amounts of water. However, the timestamp gets converted into a number which results in this:
How can I best display the consumption of water without seeing the timestamp as a line? I want the timestamps simply on the horizontal axis. Sorry for asking something so basic!
DLans Try it this way (see attached).
You should only chart the consumption with the timestamps on the X-axis as labels.
3 Replies
- Riny_van_EekelenPlatinum Contributor
DLans Try it this way (see attached).
You should only chart the consumption with the timestamps on the X-axis as labels.
- DLansCopper Contributor
Riny_van_Eekelen That was as simple as I feared it would be, thank you!
- Riny_van_EekelenPlatinum Contributor
DLans You're welcome!