Non Contiguous data in Excel 2007 Pie Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2003 I could select data across different columns (as long as it was
in the same rows) by holding down the control key and clicking on the cells
for display in a pie chart.

This feature seems to be gone in Excel 2007 and I have only had success
graphing pie charts for data that is in neighboring columns.

Does anyone know if this is possible in Excel 2007 and how to properly
select the data?

Thanks,

Josh
 
I had no trouble selecting three non-contiguous cells by hold CTRL and then
using Insert to make a pie chart in Excel 2007 (beta release 2)
best wishes
 
Yes, I also figured out that I could do it this way by first selecting the
data and then inserting the chart.
However, if I right click and Select Data.... it does not work. Not a very
good solution overall compared to the previous flexibility in Excel 2003. Now
I have to delete the old chart and create a new one everytime, paste in the
title, format everything, etc.
 
Never done it that way before. But it works in Excel 2007.
Insert -. Chart -> pie chart
right click -> source data
click the red thing in the dialog box (never did lean the name for the new
box that lets you type in it or by clicking the red at left lets you point
to cells)
Click cell1, hold CTLR and click cell 2 and then cell3
Send me a private email and I will send you a 'movie' of this happening -
made with Camtasia.
best wishes
 
Back
Top