chartsmicrosoft excel
I would like to fill the area between two graphs.
My data is in the following format:
x y
0 0
1 1
2 4
....
0 0
As you can see they start and end at the same point. For my data it draws a chart but I can't fill inside that axis area.
Example taken from the comments
Use scatter plot instead of line chart, it's more suitable for your goal.
Enter (0,0) also at the end of your series then insert - charts - scatter - scatter with straight lines (last ones).
This way also you'll be able to manage other charts in a more flexible way.
The simplest solution is to use "helper" columns to break each category into its own series, which can then be independantly formatted. For instance, in Column D:
Here's an example of what it could look like:
To further simplify things, you can format your data as an Excel Table and that will speed up the creation of your categories by automatically filling the series data. Here's what it could look like:
Best Answer
This can be accomplished in Excel, but it's not native and requires a bit of creativity. Here's a brief concept (if you provide more accurate sample data, I can provide you a better description of your specific example):