Timelines and graphing

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I want to plot two horizontal bar graphs that plot
different steps of a process (in minutes) against a
timeline that begins at 7am and increases by 15 minute
increments.

In other words I have 2 products each with 4 steps
prepare, mix, bake, and cool. Each of the steps times
vary by product. Product A: prepare (10 minutes), (Mix 65
minutes), Bake (120 Minutes), and cool (45 minutes).
Product B:prepare (10 minutes), (Mix 90 minutes), Bake
(150 Minutes), and cool (30 minutes). I want the x-axis
to begin at 7am and end at 4pm and show each of the
products steps ploted on the timeline beginning at 7am
 
Jon -

Set up the data properly, and the chart will draw itself.

Product A Product B
Start 7:00 7:00
Prepare 0:10 0:10
Mix 1:05 1:30
Bake 2:00 2:30
Cool 0:45 0:30

Make a stacked bar chart, with the series in rows. Format the Start
series to be invisible (no border, no area fill), and hide the legend
entry by selecting the legend, then selecting the word Start, and
pressing Delete. Double click on the time axis, enter 7:00 for min,
16:00 (or 4:00 pm) for max, and 1:00 for major spacing. Choose an
appropriate number format for the axis, and color the bars however you like.

Excel charts Product A lower than Product B. You can reverse this by
double clicking on the vertical axis, and on the Scale tab, checking
Categories in Reverse Order and Value Axis Crosses at Maximum Category.

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