Chart Legend: Include more Data in my chart legend than what I have graphed

[eliese0]

I have created a scatter plot chart on a separate worksheet.
This chart has about 29 Data Series to show how much a home of
certain size sold for.

x values: MIN_SQ_FEET, MAX_SQ_FEET
y values: MIN_PRICE, MAX_PRICE

The chart displays my information perfectly.

The problem is that in addition to displaying each housing project
name on the legend, we also want to see the Total Units and the Unsol
Units in the Legend. This data is not what we chart, but it
would be helpful to see it

If I just include the columns in my data series for the name i
concatenates the values into one long string, which is not easil
readable.

Is there any way to turn the legend into a mini table containing m
values in different fields?

thank

 

[Tushar Mehta]

Depending on what exactly you are plotting and what you want to
dispaly, you may want to include the additional information as
datalabels. Use XY Chartlabeler (www.appspro.com) or Chart Tools
(www.j-walk.com) to create datalabels from something other than the
series name/x/y values.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[eliese0]

Thanks for the reply.

I will look into those tools you mentioned.
It was reassuring to hear from someone else that I hadn't misse
something obvious

Elies