Forum Discussion
maite fernandez
Sep 05, 2018Copper Contributor
Coloured growth curves with Excel!
Hello, I'm new here and hope you can help me! Please, see the doc attached. That's what i want to do with excel. I already have the curves, I just need the colours! I've tried with the stacked area g...
maite fernandez
Sep 05, 2018Copper Contributor
Hey, thanks for the quick response. I know how to change the colours of the lines, what I want is to have colours between the lines, like in the doc attached.
Philip West
Sep 05, 2018Steel Contributor
in a stacked area graph that would be the fill colour.. if you dont see any colour at all is the fill turned off? or have you acidently used a stacked line graph?
Any chance you can share your workbook to look at?
- maite fernandezSep 05, 2018Copper Contributor
I do see colours when i use stacked area, but all over the graph. Attached is the data and graph. Any idea?
- Philip WestSep 05, 2018Steel Contributor
Hia,
i've tried to fix it. your graphs scatter all scatter graphs. I've rearanged your data a bit so you might want to check that, or just redo the whole thing your self, but they weren't area charts which was the problem..
- maite fernandezSep 06, 2018Copper Contributor
The problem is the Y axis.. it has to go from 45 to 110. RED should go under SDneg3, YELLOW between SDneg2 and SDneg3, GREEN between SD2 and SDneg2.
Take a look at sheet 2 in the workbook attached, I did that with shadows, but that's how it should looke (more or less) with the proper colors.