Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Data Table
This is what I want to do, if it is possible. I want to show the data table on the bottom of the chart, but I don't want it to show all the data plotted in the chart. Is it possible to remove some information from the data table, but it still be on the chart? Thanks for the help, Bob -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=522758 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Data Table
Hi,
You can not control the content of the table. If its in the chart its in the table. 2 options to work around this. Either use worksheet cells to construct your own table or use 2 charts laid over each other. The bottom chart contains all the data required for the table. The top chart contains all the data to build the chart. Obviously the top charts area will be smaller than the bottoms so the table is visible. Cheers Andy robertjtucker wrote: This is what I want to do, if it is possible. I want to show the data table on the bottom of the chart, but I don't want it to show all the data plotted in the chart. Is it possible to remove some information from the data table, but it still be on the chart? Thanks for the help, Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Strange Value in my chart data table | Charts and Charting in Excel | |||
how to reposition a data table in chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Activating a Chart object | Charts and Charting in Excel |