Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 25th 05, 06:59 PM
sami b
 
Posts: n/a
Default how do i create an exploded bar chart

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

  #2   Report Post  
Old January 26th 05, 01:13 PM
Jon Peltier
 
Posts: n/a
Default

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   Report Post  
Old January 26th 05, 01:40 PM
Andy Pope
 
Posts: n/a
Default

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
  #5   Report Post  
Old January 27th 05, 12:35 AM
Jon Peltier
 
Posts: n/a
Default

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).



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a Line-Column on 2 Axis chart that allows more... Angioletta Charts and Charting in Excel 1 December 17th 04 11:56 AM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 08:55 PM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 08:55 PM
Chart newbie help, please, How to create JohnT Charts and Charting in Excel 3 November 30th 04 04:17 PM
Setting up data to create a chart George Murray Excel Worksheet Functions 0 November 8th 04 04:33 PM


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017