ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I display my table in chart area? (https://www.excelbanter.com/charts-charting-excel/140693-how-can-i-display-my-table-chart-area.html)

Abeka

How can I display my table in chart area?
 
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

Jon Peltier

How can I display my table in chart area?
 
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
_______


"Abeka" wrote in message
...
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





All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com