Chart and data manipulation help
August 21, 2022 12:32 PM Subscribe
I have been logging the times and days that an incident has been occurring. I'd like to be able to take that data and map it in a chart so that I can easily see trends and patterns of occurrence. Sort of like this. What is this kind of chart called? Is there a way I could automatically create it from the data I've collected? I guess I'll need to know how to format that data. I'd also like to be able to manipulate the chart so I only see one specific day of the week, or only yellow squares, etc. Links to tutorials very welcome. I used to have beginner-intermediate Excel skills but they are now extremely rusty from lack of use. I can follow instructions, though!
Heat Map in Excel
I think you could use a combination of conditional formatting (and filtering) to select rows you want. Or you could use form controls.
posted by oceano at 1:00 PM on August 21, 2022 [1 favorite]
I think you could use a combination of conditional formatting (and filtering) to select rows you want. Or you could use form controls.
posted by oceano at 1:00 PM on August 21, 2022 [1 favorite]
In Excel, consider a scatter chart with no lines. It shows the data specifically and the trends are usually apparent.
posted by theora55 at 5:13 PM on August 21, 2022
posted by theora55 at 5:13 PM on August 21, 2022
You might also find it helpful to include separate columns for different parts of the date. (e.g. Find the Day of the Week as a Name, Day Function, Month Function). Then filter on these separate columns.
posted by oceano at 9:57 PM on August 22, 2022
posted by oceano at 9:57 PM on August 22, 2022
« Older Why can one kid get out of the car and the other... | What are the pros and cons of wood windows, can I... Newer »
This thread is closed to new comments.
I think you may be interested in a heat map table.
https://academy.datawrapper.de/article/308-how-to-create-a-heatmap
posted by forkisbetter at 12:47 PM on August 21, 2022 [1 favorite]