Blood Sugar Chart for Two Diabetic Cats in Google Sheets
I’m having a terrible time trying to create what I thought would be a simple line chart to track blood sugar for my two diabetic cats. I want two lines, one for each cat, tracked by date/time. I have four columns: Date, Time, Cat, and Blood Sugar. I can’t get the chart to have a separate line for each cat. Cat is the name of whichever cat I was taking the reading for at the specified Date and Time, Blood Sugar is the numeric sugar level. Any help appreciated! The data looks like:
Why can’t I get Google Sheets to display this info as a pie chart?
I am so, so frustrated right now. I imagine it’s because I’m doing something wrong, but I can’t figure out what it is. I have a decent amount of experience with Google Sheets and I’ve never had this problem before.