how do i create an exploded bar chart

#1 01-25-2005, 03:06 PM

need help to create a 3d exploded bar chart from a standard excel data
worksheet

#2 01-26-2005, 10:06 AM

My least favorite chart type, hard to use it without distorting the
data. Unless that's your intention... work for the government?

Anyway, it's like any chart. Assuming you have labels in one column (or
row) and values in the next, select this region with the data, and start
the chart wizard (use the toolbar button, or select Chart from the
Insert menu). In step 1, choose the pie chart type and the exploded 3D
subtype, then go through the rest of the wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

sami b wrote:

> need help to create a 3d exploded bar chart from a standard excel data
> worksheet

#3 01-26-2005, 10:06 AM

Hi Jon,

This will work if the OP meant pie instead of bar.

If they meant bar maybe they will post a little more detail on what an
exploding one is.

Cheers
Andy

Jon Peltier wrote:
> My least favorite chart type, hard to use it without distorting the
> data. Unless that's your intention... work for the government?
>
> Anyway, it's like any chart. Assuming you have labels in one column (or
> row) and values in the next, select this region with the data, and start
> the chart wizard (use the toolbar button, or select Chart from the
> Insert menu). In step 1, choose the pie chart type and the exploded 3D
> subtype, then go through the rest of the wizard.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> sami b wrote:
>
>> need help to create a 3d exploded bar chart from a standard excel data
>> worksheet

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

#4 01-26-2005, 02:06 PM

Isn't that amazing? What the OP had posted just didn't register. Only
what I would have written after 'exploded' (in the context of a chart
that is).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <OwJ3ry6AFHA.2016@TK2MSFTNGP15.phx.gbl>, andy@andypope.info
says...
> Hi Jon,
>
> This will work if the OP meant pie instead of bar.
>
> If they meant bar maybe they will post a little more detail on what an
> exploding one is.
>
> Cheers
> Andy
>
> Jon Peltier wrote:
> > My least favorite chart type, hard to use it without distorting the
> > data. Unless that's your intention... work for the government?
> >
> > Anyway, it's like any chart. Assuming you have labels in one column (or
> > row) and values in the next, select this region with the data, and start
> > the chart wizard (use the toolbar button, or select Chart from the
> > Insert menu). In step 1, choose the pie chart type and the exploded 3D
> > subtype, then go through the rest of the wizard.
> >
> > - Jon
> > -------
> > Jon Peltier, Microsoft Excel MVP
> > Peltier Technical Services
> > Tutorials and Custom Solutions
> > http://PeltierTech.com/
> > _______
> >
> > sami b wrote:
> >
> >> need help to create a 3d exploded bar chart from a standard excel data
> >> worksheet
>
>

#5 01-26-2005, 09:06 PM

Yep, I saw the word 'exploded', and pie just popped into my head. The
"trailer trash" of charts, as our esteemed colleague Debra once called
them.

Exploded bar doesn't make any sense, and I suppose exploded scatter is
somewhat redundant.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tushar Mehta wrote:

> Isn't that amazing? What the OP had posted just didn't register. Only
> what I would have written after 'exploded' (in the context of a chart
> that is).
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)