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 |
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/P...cle.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" wrote in message ... 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 |
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com