Selecting data in a PivotTable report

D

Duncanl

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have created a pivotTable report and now want to select the data in the table to create some graphs of the data. When I try to select data across columns the selection highlights only the column under my curser and will not select multiple columns? Any thoughts?
 
P

Pat McMillan

This is a bug we're aware of. We're currently working on a fix. As a
workaround, please click in the Name Box on the Formula Bar and type in the
range you want to select (for example, A1:C10), then press <return>. If you
expect to be selecting the same data range repeatedly, you could then click
in the name box again (while the intended range is selected) and enter any
name for the range, such as "chartdatarange", and press <return> again. That
way you will be able to easily select the range the next time you need to
select it.

Thanks,

Pat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top