PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Chart type problem
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Chart type problem
![]() |
Chart type problem |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

