Another alternative is to dispense with the inflexible and unwieldy data
table in favor of a table in the cells under the chart. You can format
this however you want, different formatting for different cells, all
that. You can include and exclude any data you want, too.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
> I don't think the data table can overlap the plot
> area...if thats what you are after.
[quoted text clipped - 42 lines]
>>
>>.
MarkD - 15 Dec 2003 17:48 GMT
Hey Jon,
Thanks for the suggestion. I was thinking about that, but
don't see an easy way to associate the data with the
actual lines (I'll be using a line graph). I don't want to
use a legend as that would make things reduntant.
I'll see if your website has any solutions regarding this,
but off-hand, can you think of any?
Thanks,
-Mark
>-----Original Message-----
>Another alternative is to dispense with the inflexible and unwieldy data
[quoted text clipped - 56 lines]
>
>.
Jon Peltier - 15 Dec 2003 18:30 GMT
Mark -
If your lines have distinct colors, you could use the colors for the
text in the relevant rows of the table. Or you could try the Label Last
Point macro on my site:
http://www.geocities.com/jonpeltier/Excel/Charts/LabelLastPoint.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
> Hey Jon,
>
[quoted text clipped - 87 lines]
>>
>>.