Add curve line to graph?

**Leegps** · 07-23-2018, 08:38 AM

Morning All,

Have made a line graph with x&y data, the blue line is what I have on screen already, I have drawn on by hand the two intersecting black lines and shaded the top part of the curve in green by hand.

My question is, is there any way you know of to show the hand drawn parts on Excel?

The maths itself is easy enough as I not need to be 100% accurate so just finding the area on a triangle, but if I add this as a separate column excel tries to add as a separate series

**dflak** · 07-23-2018, 10:52 AM

If it can be done, you will find the answer here: http://www.peltiertech.com/Excel/Charts/. The site does a great job with step-by-step instructions.

In fact, this https://peltiertech.com/fill-under-b...n-excel-chart/ might be specifically what you are looking for.

**Leegps** · 07-23-2018, 11:17 AM

Thanks for the reply, i will give a look at now!

**Leegps** · 08-14-2018, 03:46 AM

Morning All,

Have managed to browse to the link above and get this to work but it's not quite what i was after, do you think it would be able to combo with a radar chart to "fill in" along the line as shown in the above image attachment?

**MrShorty** · 08-14-2018, 10:54 AM

I think that a lot of things are possible, so I would not be surprised if it is possible to use a line + radar to get what you want. However, I think that the line + stacked area approach in Peltier's tutorial should be easier. Can you describe what you tried? What it did well? What you want different? Perhaps an updated sample file with the latest attempts? I guess my expectation is that it will be easier to modify what you have done based on Peltier's tutorial than to try to create something completely different using an untested technique.