One-click Automatic Charting

[gohar.saleem]

Hello guys,

I have different kind of data for forecast. What I want is to be able
to create a chart with just one click on the worksheet. I know the F11
function but for that you have to select the data and doesnt give you
a concised chart. I want to get a chart for example for different
quarters of the year, monthly basis, customer basis, with just one
click. Maybe there are different buttons (or drop-down buttons) for
each kind of chart to be created. How can I go about it?

Any kind of help would be very appreciated!

-Garry

 

[Jon Peltier]

You could program your own custom buttons to generate charts for you, but
they're not included as native Excel features. That would be impossible,
because your idea of critical charts would differ from mine, and to satisfy
everyone Microsoft would need more buttons than there are pixels on screen.

The Excel 97-2003 chart wizard is actually not a bad interface, because in
just a few clicks you are able to produce many different types of chart.
Excel 2007's chart making protocol is a step backwards, IMO, because you get
a rudimentary chart which you then have to manually adjust pieces of.

If you always make charts from the same data range, and the features of the
chart are always the same, then you could record a macro while making one
such chart, then tweak the recorded code. Attach it to a button, and you've
got your feature.

- Jon