Stacked Area Graphs - How to get a Horizontal "Value" Axis

Hi!

I am struggling to format my horizontal axis properly on a stacked area graph and would appreciate any help you guys can give me!

I am trying to create a stacked area graph (total water discharge with proportions of groundwater flux and runoff) but I can not figure out how to turn the horizontal axis into a "value axis". I want the horizontal axis to increase proportionally by day, with each increment representing a day, from 0 days to 10 days. Unfortunately my data includes discharge information at 0.1 days and 0.5 days, which excel has turned into increments, making my x-axis into a category axis with 0.1, 0.5 and 1.0 being the first three categories. I am wondering if there is any way for me to turn the horizontal axis into a Value Axis (without changing the Vertical Axis) so it will increase with a scale of days rather than by what it assumes are categories. Sorry if this is confusing. I have attached my excel file to illustrate my difficulties. I am fairly inexperienced with excel but I have tried to find information online to help resolve my problem with no luck. Does anyone have any advice, or could anyone direct me to a thread that has solved the problem?

I am using Excel 2007.

Thank you!

Terrafish

Assignment 4 Graph.xlsx

Andy,

Thanks so much for your help! You're a lifesaver .