• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Changing the chart colour different

webmax

Member
Hi

I am attaching the excel file it contains three data projected , achieved and target. If i put the chart it is giving only one color ie blue color.
Any body guide how to differentiate with color. My requirement is the Target chart show in blue color, achieved chart in green color, projected chart in yellow color.

Regards
Shahul
 

Attachments

  • chart colour.xlsx
    13.3 KB · Views: 3
Shahul

Select the chart
then click on a Blue Bar
then click on a Blue Bar again

Now you only have a single bar selected
Press Ctrl+1
Format Data Point
Select Fill color/style

Then repeat this for the other Bar

upload_2018-10-2_12-55-37.png
 

Attachments

  • upload_2018-10-2_12-53-15.png
    upload_2018-10-2_12-53-15.png
    19.9 KB · Views: 4
Back
Top