chartsmicrosoft excel
How do I shade the area under a straight line graph in Excel, along the x-axis? The graph data points are shown below.
0-16.67
170-16.67
170-6.712
187.5-6.712
652-25.352
670-33.408
910-33.408
910-0
I have tried using area plot and selecting time for the x-axis, but the values on the x-axis differ from the real data.
Make sure you have a scatter chart in Excel
Here is the difference:
1) Insert a combo chart
2) For the lower and upper values select Area (not stacked area chart type)
3) For the middole value, select Line chart type
4) Click "OK" -- you will likely not see the areas like you want it, the higher value may hide the lower value area -- this is normal
5) Right click on the chart and choose "Select Data"
6) Move each series up or down so all data becomes visible by clicking on the two triangles -- the chart should update as you go.
7) Once the chart is all right, click "OK"
8) Select the Plot Area, Right Click on it and Choose Format Plot Area, then choose whatever colour you want for the fill
You should end up with something that looks like this:
Best Answer
Assuming these data points are listed as (x,y) and you are looking for a graph with an area plot.
This might be because the data for x and y axis might be incorrectly selected.
Once you have inserted an area chart in excel, navigate to
Select Dataand in place of Horizontal (x-axis) choose the range for 0, 170, 170, 187.5..The chart finally looks like this: