Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 05, 10:41 AM
Svetlana
 
Posts: n/a
Default hide column but show chart

Hello,

I use Excel 2003.

I want to show people a chart from an Excel sheet on my computer.
These people will only come and watch what I show them on the monitor
but will not receive my Excel file.

The chart represents a pie with different percentages of prices listed
in a column. The column and the chart are on the same sheet.

It is okay if people see the chart (no prices on it, only percentages)
but I don't want them to see the column with the prices.

I tried to group or hide the coulumn with prices but as soon as do it
then the chart disappears.

Is there a simple way to have the column and the chart on the same
sheet and temporarily hide the column and keep the chart?

Thanks.

Sveta

  #2   Report Post  
Old January 14th 05, 10:49 AM
Andy Pope
 
Posts: n/a
Default

Hi,

Select the chart and then use the menus Tools Options.
On the Chart tab of the dialog is a 'Plot visible cells only', which you
can uncheck.

Cheers
Andy

Svetlana wrote:
Hello,

I use Excel 2003.

I want to show people a chart from an Excel sheet on my computer.
These people will only come and watch what I show them on the monitor
but will not receive my Excel file.

The chart represents a pie with different percentages of prices listed
in a column. The column and the chart are on the same sheet.

It is okay if people see the chart (no prices on it, only percentages)
but I don't want them to see the column with the prices.

I tried to group or hide the coulumn with prices but as soon as do it
then the chart disappears.

Is there a simple way to have the column and the chart on the same
sheet and temporarily hide the column and keep the chart?

Thanks.

Sveta


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


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
Floating column chart Gian Charts and Charting in Excel 2 January 12th 05 03:48 AM
On a combination chart how do i get 2 lines and 1 column? Richie Charts and Charting in Excel 1 December 22nd 04 01:27 PM
On a scatter chart show two point have same value Maz Page Charts and Charting in Excel 1 December 16th 04 02:00 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 05:31 PM


All times are GMT +1. The time now is 02:28 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017