+ Reply to Thread
Results 1 to 2 of 2

hide column but show chart

  1. #1
    Svetlana
    Guest

    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. #2
    Andy Pope
    Guest

    Re: hide column but show chart

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1