Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 09, 04:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 2
Default Graph - Easy Question

I'm sure this is pretty easy but i have little to no skill with excel. I'm
using MS Excel 2003 and i want to create a graph compare 3 columns. The first
column has the date something was created, the second column has the date it
was completed and the last column has how many hours it took in total.

For example

06/28/09 12:00 06/28/09 05:00 5 hours

How would I go about creating this graph?
Thanks in advance


  #2   Report Post  
Old June 29th 09, 05:36 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Graph - Easy Question

With available information i assume you are looking to chart the hours date
wise.

Suppose you have your data in ColA to ColC with headers in Row1. For the
below example I assume you have data from row2 to row10

From menu InsertChart
Select say Line chartNext
Selct Tab 'Series'click Add
Select 'Category X axis labels' and select range A2:A10
Select 'values' and select the range C2:C10
Right click on x axisFormat Axisand custom format to dd-mm


http://peltiertech.com/Excel/ChartsH...artWizard.html

If this post helps click Yes
---------------
Jacob Skaria


"ITGuy" wrote:

I'm sure this is pretty easy but i have little to no skill with excel. I'm
using MS Excel 2003 and i want to create a graph compare 3 columns. The first
column has the date something was created, the second column has the date it
was completed and the last column has how many hours it took in total.

For example

06/28/09 12:00 06/28/09 05:00 5 hours

How would I go about creating this graph?
Thanks in advance



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any ideas for making this graph type easy for other users? Del Cotter Charts and Charting in Excel 5 December 5th 07 12:47 PM
Easy VBA question Dallman Ross Excel Discussion (Misc queries) 2 August 6th 07 01:26 AM
Is there an easy way to create automation in a graph? Duser Charts and Charting in Excel 1 January 21st 06 08:01 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM
easy question Dahlman Excel Worksheet Functions 3 April 1st 05 11:11 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017