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