custom charts?

J

Jeremy Fieldsend

Is there anyway of creating a chart from scratch? None of the existing
combinations quite suit and I can't seem to alter any of them to fit my
needs (a combination of bar chart, area chart and single line.)
Thanks
 
J

JE McGimpsey

Is there anyway of creating a chart from scratch? None of the existing
combinations quite suit and I can't seem to alter any of them to fit my
needs (a combination of bar chart, area chart and single line.)
Click to expand...

Yes, though there are some limitations. From XL04 Help's "Change the
chart type of an existing chart":
For most 2-D charts, you can change the chart type either of an
individual data series or of the entire chart, but for bubble charts,
you can only change the type of the entire chart. For most 3-D
charts, changing the chart type affects the entire chart. For 3-D bar
and column charts, you can change a data series to the cone,
cylinder, or pyramid chart type.
Click to expand...

So change the type of the applicable series.

and you can then save that combination in a Custom Chart Type. From
Help's "Create, share, or delete your own chart types":
 
Top