Chart Wizard

[wgnewman]

Where, oh where, has that little chart wizard gone? Oh where, oh where can
it be? I thought the 2007 version would be great for charts, but I can't
replace an entire series of data in a chart. Below the "chart data range"
box it reads, "The data range is too complex to be displayed. If a new range
is selected, it will replace all of the series in the Series panel." In the
2003 version, I was able to copy a chart and click on the chart wizard and
select/grab the new data, change the heading and have a new chart. I was
able to create over 100 charts per book with the 2003 chart wizard. I really
need help. This is not good news for me.

 

[ShaneDevenshire]

Hi,

The chart wizard is gone, not hidden, sad to say. When you select a range
in the Select Data dialog box you need to be very careful, at least in my
copy of Excel, Excel seems to like to put a + after the current selection
when it should remove it or put a comma in. I suppose this could be me, but
I'm not really a fan of this "feature".

 

[wgnewman]

What do you recommend?

Hi,

The chart wizard is gone, not hidden, sad to say. When you select a range
in the Select Data dialog box you need to be very careful, at least in my
copy of Excel, Excel seems to like to put a + after the current selection
when it should remove it or put a comma in. I suppose this could be me, but
I'm not really a fan of this "feature".

 

[Jon Peltier]

The chart wizard is gone. IMO it was a mistake to remove it, but it goes
along with the new user interface philosophy of making Excel as hard and
inefficient as possible for the users.

You can still change the source data for the chart. Ignore the "too complex"
warning (that would appear in previous versions of Excel as well, and I
don't think it occurs under any different circumstances in 2007), select the
contents of the selection box and select the new range.

- Jon

 

[wgnewman]

When I select the contents of the chart data range selection box, I am
required to type in a string of data that encompasses about 40 cells. It
would be practically impossible for me to type that data in for 100 charts.
It appears to me that the only alternative is to recreate every chart every
time. Do you think a patch will be created to solve this problem?

 

[Jon Peltier]

Are you unable to select the data? Why does it need to be typed?

- Jon