chart auto open

  • Thread starter Thread starter satellite
  • Start date Start date
S

satellite

I am really, really new at this but I have a program that I wrote i
excel that provides 8 different results. I was wondering if there i
any way to automatically open those cells to display a chart?

If anyone can help me I would certainly appreciate it.

Thank
 
Hi
what do you mean with 'open the cells'?
normaly you can easily select the cells and goto 'Insert - chart'.
Choose your chart type and format it. If your values change the chart
will be updated automatically
 
I appreciate that Frank. I got that to work.

How do I set up a cell so that no data can be entered? I have cells
between that I need to close so that when the user hits enter it will
carry them to the next cell that requires data.]

thanks in advance.
 
Hi
One way:
- select all cells for which data entry is ALLOWED
- goto 'Format - Cells - Protection' and uncheck protection for theses
cells
- Protect your workbook ('Tools - Protection')

This will prevent the data entry (though the cursor will not move
automatically)
 
Back
Top