Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 05, 05:56 AM
Jon Peltier
 
Posts: n/a
Default How to make a stacked bar chart using time?

Hi Guido -

To make this work more easily I inserted a column with dummy labels (a
through f). The cell above a and to the left of Dr X is blank.

Dr X Dr Y Dr Z
a 2:03 3:00 1:00
b 0:20 2:00 0:30
c 0:40 1:00 0:30
d 2:45 1:00
e 0:15
f 2:10

Select the range and make a stacked bar chart, with the series in rows.
The doctors are linked by the series (series "a" has a value for each,
for example).

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

Father Guido wrote:

Hi,

I have the following data to plot on a stacked bar chart, and
displayed as time.

Dr X Dr Y Dr Z
02:03 03:00 01:00
00:20 02:00 00:30
00:40 01:00 00:30
02:45 01:00
00:15
02:10

08:13 07:00 02:00

This is time in hours and minutes.

I need the result to look like this...

Dr.X bar [02:03][00:20][00:40][02:45][00:15][02:10]
Dr.Y bar [03:00][02:00][01:00][01:00]
Dr.Z bar [01:00][00:30][00:30]

where [02:03] represents a colour to represent 2 hrs & 3 mins etc.

If I just select the Dr. X data I can get a stacked chart, but as soon
as I add either Dr. Y or Dr. Z data the whole chart turns into one
large bar, not three separate bars. I can of course create three bars
if I just plot the totals, but I want the individual parts of the
total (stacked bar) to show separately. What do I need to do to keep
these three sets of data separate? I'm using Windows XP with Excel XP.

Thanks in advance!!!

Norm


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 can I create a stacked bar chart with stacked bars side by TimMC Charts and Charting in Excel 1 January 22nd 05 02:09 AM
Make a pie chart of a budget Zoddious Charts and Charting in Excel 1 December 30th 04 01:15 AM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 04:31 PM
Stacked Bar Chart Barb Reinhardt Charts and Charting in Excel 7 December 9th 04 01:54 PM
Make A Universal Time Converter [email protected] New Users to Excel 1 December 2nd 04 04:31 AM


All times are GMT +1. The time now is 11:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017