I have a table and I create a line diagram from this table. I want the table
(data) to be shown in chart area. How can I do that? Regards
Several ways:
Chart menu > Chart Options > Data Table tab.
Chart sheet: Camera tool (Tools menu > Customize > Commands tab, select
Tools in left list, scroll 3/4 of the way down right list, drag the Camera
to a convenient toolbar). Select the range, click the Camera icon, click in
the chart.
Embedded chart: Convert to chart sheet, use Camera tool as above, convert
back.
Embedded chart: Create the table next to the chart, use formatting as
required.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
>I have a table and I create a line diagram from this table. I want the
>table
> (data) to be shown in chart area. How can I do that? Regards