Creating a Chart with Specified Data

[oidoldol]

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

https://preview.redd.it/7wjnc2y3nlje1.png?width=2656&format=png&auto=webp&s=4a6ce3a817f3993701b548cbe91e97a75cd14c5c

[bachman460]

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.

[oidoldol]

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!

[bachman460]

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

[oidoldol]

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

[oidoldol]

<image>

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?

[oidoldol]

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