Elena has attended:
Excel Charting course
PowerPoint Intermediate Advanced course
Graphics
Hello,
I have a straight-fwd one line graphic, that goes above ander the value of 0 in the vertical axis. I would like the line to be red when the value is under 0 and blue when it's abobe 0. Cuold I do that? how?
Thank you,
Elena.
RE: graphics
Hi Elena,
Thank you for the forum question.
It is easy to do if it was a column chart but much more difficult in a line chart.
You cannot do it using the Excel chart tools, but by creating a complex data model. I found an example online I have attached.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
ConditionalLine2.xlsRE: graphics
Hello and thank you for your reply. oh dear - could I then make the 0 horizontal line red?
RE: graphics
Hi Elena,
Sorry about the delayed answer.
If you double click the 0 horizontal line you can change the colour. Click LINE COLOR to the left and SOLID LINE to the right and select a colour.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
