PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Chart type problem

Reply

Chart type problem

 
Thread Tools Rate Thread
Old 02-07-2008, 12:09 PM   #1
xavi garriga
Guest
 
Posts: n/a
Default Chart type problem


I have a problem to create a chart. I have this data:

Machine part minute start minute stop
G A 0 282
G B 282 359
Ma C 0 298
Mb D 0 183
Mb E 183 497
Pa F 110 278
Pb G 0 172

I want a chart with bars which draws the time that each part is in each
machine like this for machine G:

----------A----------
------B-----

But I don't know how to do this, could you help me??
If you don't understand anything of the question please ask me, I know my
english is terrible!

Thanks!
--
atrep
  Reply With Quote
Old 02-07-2008, 01:58 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Chart type problem

Don't apologize for your English. I wouldn't have known you weren't a native
speaker.

This is like a Gantt chart. You need to set up your data so you have a start
time and a duration (end minus start). Make a stacked bar chart using the
start and duration as your data, then format the start bars so they are
invisible (no border, no fill).

Gantt charts:
http://pubs.logicalexpressions.com/...icle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

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


"xavi garriga" <xavigarriga@discussions.microsoft.com> wrote in message
news:5EC50BD3-EFC7-40BA-A990-FD09EB085749@microsoft.com...
>I have a problem to create a chart. I have this data:
>
> Machine part minute start minute stop
> G A 0 282
> G B 282 359
> Ma C 0 298
> Mb D 0 183
> Mb E 183 497
> Pa F 110 278
> Pb G 0 172
>
> I want a chart with bars which draws the time that each part is in each
> machine like this for machine G:
>
> ----------A----------
> ------B-----
>
> But I don't know how to do this, could you help me??
> If you don't understand anything of the question please ask me, I know my
> english is terrible!
>
> Thanks!
> --
> atrep



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off