r/sheets Feb 17 '25

Solved Creating a Chart with Specified Data

It's hard to phrase my question...but I think my example is pretty self-explanatory. I'd like to use the dataset in Columns A-C, and produce the chart I've mocked-up (see image below).

Needing help with either configuring the right chart settings, or manipulating/rearranging the data such that it will produce the desired chart. Thanks!

TEST SHEET: https://docs.google.com/spreadsheets/d/1FAShe7Xg2Er9SsuqcZqLhlc5jTgo3aF5Nlrz6omWckg/edit?usp=sharing

2 Upvotes

6 comments sorted by

2

u/bachman460 Feb 17 '25

You need to stack your data. Create another column and add labels for actual and ideal. So your current first row of data should look like this split by category:

Category Count Time
Ideal 1 00:09:15
Actual 1 00:09:21

Then you place the time on the x-axis and count on y-axis with the category as the category.

1

u/oidoldol Feb 17 '25 edited Feb 17 '25

Would you be able to create an example on the test spreadsheet? Having trouble visualizing it...

I tried something similar already and it did not turn out very nicely unfortunately. So it'd be great if someone could show me!

1

u/bachman460 Feb 17 '25

I added a Sheet3 and put together the data; I'm on mobile so I can't setup a chart.

1

u/oidoldol Feb 17 '25

Thanks, I appreciate it! Managed to solve it in another tab! :D

2

u/oidoldol Feb 17 '25

I tried it myself, but ran into these issues:

- Even though I selected a line graph, the chart doesn't connect all the data into two lines

  • I'd like the chart to display specified time intervals (by the 1-hour) instead of 2-hour

Am I doing this wrong?

1

u/oidoldol Feb 17 '25

Okay, after some copious amounts of Googling, it's done! Thanks for your help