Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Using Hidden data for a chart

with your chart selected, go into Tools=Options, Chart tab and unclick Plot
Visible Cells Only.

--
Regards,
Tom Ogilvy


"Rick" wrote in message
news:iSRgc.27920$0b4.36798@attbi_s51...
Hi everyone,

I am using source data from a column that I want to be "hidden" on a

worksheet. The chart is fine
until I hide the column then the chart is blank and the source data

dispappears? Is there a way to
use "hidden" ranges as source data?

TIA,

Rick



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
Chart data from hidden rows (not columns) wildetudor Charts and Charting in Excel 1 January 13th 09 03:52 PM
Displaying hidden data on a chart Nick Terry Charts and Charting in Excel 2 February 8th 07 02:58 PM
Making chart with hidden Data dandigger Excel Discussion (Misc queries) 2 September 16th 06 07:55 PM
Hidden data - hidden chart Brisbane Rob Charts and Charting in Excel 2 April 1st 06 09:51 PM
Hidden Data to show on the Chart Brisvegaslad Charts and Charting in Excel 2 August 12th 05 09:17 AM


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