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

--
Message posted from http://www.ExcelForum.com

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

In article <(E-Mail Removed)>, eliese0
<<(E-Mail Removed)>> says...
> 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 a
> 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 Unsold
> 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 it
> concatenates the values into one long string, which is not easily
> readable.
>
> Is there any way to turn the legend into a mini table containing my
> values in different fields?
>
> thanks
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>

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

--
Message posted from http://www.ExcelForum.com