Can not add user-defined charts

  • Thread starter Thread starter David DeRolph
  • Start date Start date
D

David DeRolph

Hi,

That's because you have not followed the instructions.
Your screen shot is of step 1 in the chart wizard.

Once you have the chart formated as required right click the chart area
and from the menu pick Chart Type.
The dialog will be very similar but the caption will be 'Chart Type'.
Now follow the steps of Custom Type, User Defined and the Add button
should appear.

Here is another page by Jon Peltier on the subject.
http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

Cheers
Andy
 
The procedure described there should work. It looks like you overlooked a
step. The Add.. button should appear in the left-under corner, but it is
context-sensitive, i.e. only appears when in the Custom Types tab, the
User-defined radio button is selected in "Select from".
GL,
Henk
 
I did follow the instructions in the referenced article but I now realize
those instructions are erroneous. The article says to start the procedure
from the Insert menu. That's what I did, and it does not work.

Now, after carefully reading the info in Excel's Help for "Add or delete a
user-defined custom chart type", I understand I must either right click on
the chart or go to Chart, on the main menu, and select Chart Type, Custom
Types, select User-defined, etc. And, that does work; it displays the Add
button.

Hi,

That's because you have not followed the instructions.
Your screen shot is of step 1 in the chart wizard.

Once you have the chart formated as required right click the chart area
and from the menu pick Chart Type.
The dialog will be very similar but the caption will be 'Chart Type'.
Now follow the steps of Custom Type, User Defined and the Add button
should appear.

Here is another page by Jon Peltier on the subject.
http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html

Cheers
Andy
 
Sorry David, you are right.
I incorrectly read only the part "Select Chart | Chart Type", which is
correct, and not the rest of the sentence.

Anyway glad your sorted.

Cheers
Andy
 
Back
Top