#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Bar Chart


I have some information that I would like plotted using a bar
chart,however to get it to appear the way I want it is a bit tricky.

Information:
Age Male Female
0-4 7.9 6.5
5-9 7.0 7.2
10-14 6.9 8.3

I would like the graph to show age in the middle, male on the left side
of age and female to the right side of age
using horizontal bars to represent the values for male and female.

7.9<-----0-4----6.5
7.0 <----5-9-----7.2
6.9 <---10-14---8.3


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default Bar Chart

Hi Shoraz,

Tricky maybe. But clearly explained here by Jon, as usual :)
(http://www.geocities.com/jonpeltier/...f.html#tornado)

Shoraz Hosein wrote:
I have some information that I would like plotted using a bar
chart,however to get it to appear the way I want it is a bit tricky.

Information:
Age Male Female
0-4 7.9 6.5
5-9 7.0 7.2
10-14 6.9 8.3

I would like the graph to show age in the middle, male on the left side
of age and female to the right side of age
using horizontal bars to represent the values for male and female.

7.9<-----0-4----6.5
7.0 <----5-9-----7.2
6.9 <---10-14---8.3


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


--

Cheers
Andy

http://www.andypope.info

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
Dynamic chart- curve dropping to zero ( chart type- Line) vmohan1978 Charts and Charting in Excel 0 February 1st 10 09:11 AM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Creating a chart(? pie chart) that shows customers,dates and machi Mark M Charts and Charting in Excel 1 August 20th 08 10:19 PM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? lpenndorf Charts and Charting in Excel 1 February 7th 07 04:32 PM


All times are GMT +1. The time now is 06:57 PM.

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

About Us

"It's about Microsoft Excel"