I have a list of temperature readings, dates and times (morning, afternoon, evening) I want the chart to group the morning, afternoon and evening temperature readings together for each date on the graphs but I can't get it to display correctly? I've uploaded the file. Can anyone help?
Last edited by fabrecass; 09-03-2021 at 11:02 AM.
My suggestion is to combine the 3 locations together and format them as a table, then use PivotTables and PivotCharts, with slicers.
In doing so, you will be able to compare the temperature by Time of Day and by Location.
temperature.png
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks