• 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.

Graph

K

Kanagat

New Member
Gurus in Excel :)

I need help, I've attached file with the description. Well i need to create chart (area) using information from 3 rows and i'm stuck to get in one area graph.

Any suggestions are welcome.

Regards,
K
 

Attachments

  • Book1.xlsx
    10.9 KB · Views: 6
Don't understand exactly what you are looking for, but one of the lines in your sheet mentioned it only needed the Prj. Amount and the Value... so not sure what is required of the phases. Have a look at the file I've attached though.
 

Attachments

  • Book1(6).xlsx
    13.9 KB · Views: 5
Good luck getting different colours into an Area Chart. I have not seen it. That doesn't mean it is not possible it is unlikely though.

The values for Santi skew your data and any Standard XL chart no matter how brilliant will struggle to show the data with any meaning.

Here is your data with the colours and without Santi as I can't work this individual in and have the data mean anything.

Take care

Smallman

EDIT: Mmmm Can't seem to upload my file. It is always temperamental from this computer.
 
You must log in or register to reply here.
Back
Top