PC Review


Reply
Thread Tools Rate Thread

Chart type problem

 
 
xavi garriga
Guest
Posts: n/a
 
      2nd Jul 2008
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
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      2nd Jul 2008
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" <(E-Mail Removed)> wrote in message
news:5EC50BD3-EFC7-40BA-A990-(E-Mail Removed)...
>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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic chart- curve dropping to zero ( chart type- Line) vmohan1978 Microsoft Excel Charting 0 1st Feb 2010 09:11 AM
" some chart types cannot be continue with other chart type sele sandeep Microsoft Powerpoint 1 28th Jun 2008 08:06 AM
Pivot Chart: cannot apply the default chart type... doco Microsoft Excel Charting 1 17th Jan 2005 04:55 PM
Adding a line Chart Type to a stacked-clustered Chart Type =?Utf-8?B?RGViYmll?= Microsoft Excel Charting 2 5th Jan 2005 11:25 PM
Customizing Chart Type - Stacked Bar and Line Chart JD Microsoft Excel Charting 2 4th Nov 2003 05:58 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:43 PM.