Posted to microsoft.public.excel.worksheet.functions

GMc[_2_]

external usenet poster

Posts: 10

Chart Issue With Hidden Cells

I have a chart in an excel 2007 worksheet where I want to hide the
source data from the end user. The chart and raw data are on the same
worksheet. When I hide the columns for the raw data the chart goes
blank (empty chart).

Its my preference not to create a new sheet for the chart, is there a
way to keep the chart updated even though the raw data cells are
hidden ?

Thanks

GMc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
drag data vertically over hidden cells.. ignore hidden cells	Derwood	Excel Discussion (Misc queries)	1	March 6th 08 10:59 PM
Chart resizes with changes to hidden cells	Pflugs	Excel Discussion (Misc queries)	2	August 3rd 07 03:08 PM
Hidden data - hidden chart	Brisbane Rob	Charts and Charting in Excel	2	April 1st 06 09:51 PM
How do I paste hidden cells and keep them hidden?	steven345	Excel Discussion (Misc queries)	0	January 30th 06 05:50 PM
Chart disappears when source data cells are hidden	Disappearing charts	Excel Discussion (Misc queries)	2	December 5th 04 03:24 AM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us