ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Tables (https://www.excelbanter.com/charts-charting-excel/152323-data-tables.html)

Rose

Data Tables
 
Is there any way to choose only part of my data to appear in a data table? I
have a line and bar chart on two axis and would like the bar data in a data
table and the line data with data labels.

Jon Peltier

Data Tables
 
Could you remove the data table from the chart, and make your own table in
the cells near the chart? Compared with the relative inflexibility of a
chart's data table, a worksheet table lets you put any data into it, format
it however you want, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rose" wrote in message
...
Is there any way to choose only part of my data to appear in a data table?
I
have a line and bar chart on two axis and would like the bar data in a
data
table and the line data with data labels.





All times are GMT +1. The time now is 06:50 PM.

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