Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JimP
 
Posts: n/a
Default Data table in a graph

Is it possible to show a series in a data table in a graph, and not show
(hide) the series in the graph?
  #2   Report Post  
Posted to microsoft.public.excel.misc
SAR
 
Posts: n/a
Default Data table in a graph


Plot your chart with data table. Go to the chart, right click on the
individual series you do not want to show, choose "Format Data Series",
change border to "none" and area to "none". The hidden series still
appears in the data table.


--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=553595

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
Deleting data in a table from excel export Secret Squirrel Excel Discussion (Misc queries) 0 February 9th 06 02:21 AM
How to Append the Data to the Master Table Shiva Excel Worksheet Functions 7 November 8th 05 05:00 AM
Data in table, may need to convert to columns with OFFSET? Ron H Excel Discussion (Misc queries) 5 July 31st 05 06:44 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Data Table - Graph Links Breaking!!! Geise, Brad Charts and Charting in Excel 1 March 31st 05 12:34 AM


All times are GMT +1. The time now is 12:12 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"