Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine a Bubble chart with other chart type | Charts and Charting in Excel | |||
Chart type not remembered in a pivot chart | Charts and Charting in Excel | |||
Chart Type toolbutton instead of Chart Wizard | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |