Can I make a timeline bar graph with two types of data in Excel?

Question

I used the search function and could not find an answer for this.

I have data that looks like the following:

I would like one bar graph with the date on the x-axis and "Inches" on the y-axis, but I would like the color of the bar to change depending on the 'Type' of Y data. When I try to use the charts under the "insert" tab, this does not work. It makes one huge plot with all of the information crammed into the x-axis. I am fairly new to this sort of thing, however, and could be doing things wrong.

Any advice would be hugely appreciated. Please let me know if there is any information that I can add to make this question more helpful. Thanks in advance.

Edit: I am new to asking questions like this, if anything is done incorrectly, please let me know and I will try to fix it. Thanks so much for your patience.

Answer 1

If you organize your data into three columns: Date, Irrigation, and Precipitation.

Then from the Insert ribbon, select a 2D chart. The default chart settings produces a chart like this: