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

Father Guido wrote:


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

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!!!


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