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

Scatter grams and legends

shirin555

New Member
Hello,


I am seeking help with legends on a scatter chart.


The purpose of my chart is to visually illustrate several internal projects, based on priority (X axis) and urgency (Y axis). I have no problem charting the different points, but experience difficulty when trying to distinguish the projects. Excel 2007 automatically colours each project in blue, so there is no way of telling which project is which by just looking at the chart. I know how to change the colours of each individual point on my diagram, but I cannot create a legend that explains the different data points.


I’m sure this has something to do with how I have arranged my data, but I can’t figure it out.


Any help would be appreciated.


Thanks
 
Shirin

This will help you out

http://support.microsoft.com/kb/213750
 
Back
Top