Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which type of graphic should I use?
Hi All,
I have got this problem: I have a series of arrival and departure times which I want to put in a graphic in Excel. My problem is that I can't find the right graphic for this data, it's not a line, bar or circle diagram. Anyone got ideas how to visualise this data? Thanks in advance, Greetings, Finn |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which type of graphic should I use?
Finn wrote:
Hi All, I have got this problem: I have a series of arrival and departure times which I want to put in a graphic in Excel. My problem is that I can't find the right graphic for this data, it's not a line, bar or circle diagram. Anyone got ideas how to visualise this data? Thanks in advance, Greetings, Finn Probably depends on what you are trying to show. An XY chart might work. I played with some random data, with arrivals and departures in separate series. With x-values of full date-time, and y-values of time-only, you would be able to see concentrations of arrivals/departures with respect to time and date. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which type of graphic should I use?
Hi,
Perhaps you are looking for a gantt chart http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Finn" wrote in message ... Hi All, I have got this problem: I have a series of arrival and departure times which I want to put in a graphic in Excel. My problem is that I can't find the right graphic for this data, it's not a line, bar or circle diagram. Anyone got ideas how to visualise this data? Thanks in advance, Greetings, Finn |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which type of graphic should I use?
Thanks in advance,
Greetings, Finn Hi All & Andy, This is where I was looking for! Also was usefull the high/low/opening like for stockdata. Thanks! Finn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert date type to text type | Excel Discussion (Misc queries) | |||
Schedule Type Graphic/Forumula | Excel Worksheet Functions | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) |