#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 38
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Tables chris Excel Worksheet Functions 1 April 27th 06 12:01 AM
***Two Input Data Tables*** rbekka Excel Discussion (Misc queries) 1 October 21st 05 02:05 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Worksheet Functions 1 August 24th 05 10:35 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Discussion (Misc queries) 0 August 24th 05 07:29 PM
How to cause a pivot tables to not summarize data - just report the data Greybeard Excel Discussion (Misc queries) 0 July 27th 05 10:21 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"