View original (French)

Different background colors in the chart

Solved
giova.44 Posted messages 160 Registration date   Status Membre Last intervention   -  
giova.44 Posted messages 160 Registration date   Status Membre Last intervention   -

Hello,

I would like to have 4 different background colors in an Excel chart.

I have tried and searched a lot... but I can't manage to do it.

I'm including an image of what I would like in the attachment (I modified the image with added colors, but I really want to do it in Excel if possible).

I would like to attach my Excel file, but I don't know how to do it?

Thank you in advance


4 réponses

Réponse 1 / 4
danielc0 Posted messages 2137 Registration date   Status Membre Last intervention   270
 

Hello,

You can prepare an image from colored cells:

You take a screenshot and use this image to insert it into the formatting of the tracing area:
0
Réponse 2 / 4
giova.44 Posted messages 160 Registration date   Status Membre Last intervention   3
 

Thanks for this idea, I will test it

I thought we could do that with the graph options in Excel

But your idea will do the trick

Thanks
0
Réponse 3 / 4
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 

Hello.

To attach a file: https://forums.commentcamarche.net/forum/affich-37996441-utiliser-cjoint-com-pour-heberger-des-fichiers

To create 4 color ranges directly from the data table, my various attempts have been in vain. You should indeed follow Daniel's suggestion.

Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)
0
Réponse 4 / 4
giova.44 Posted messages 160 Registration date   Status Membre Last intervention   3
 

I followed Daniel's suggestion and it's perfect.
Thank you also for the information on how to host files.

It's sorted for me.

Best regards
0