Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a chart representing hours used
I don't know if it's possible or at least I am not aware of how to do it, but
I need to create a chart using days as the column, be it vertical or horizontal, and showing the hours covered by a schedule, basically saying on date X I covered 1000 to 1930 hours, hour format is no big deal, but I can't seem to make it work properly. It seems simple but I don't know excel well enough to figure it out. I would like to be able to do this for a monthly period. Any suggestions would be greatly appreciated. What I get now is either I get the date compared to hours or I get the dates removed and replaced with numbers of the column rather than correct date. I have hours in both actual hourly format and in general 4 digit representation. It doesn't matter which way it needs to be, I can change that as necessary. |
#2
|
|||
|
|||
Based on what you've said here, I'd probably do something like this
http://www.peltiertech.com/Excel/Cha...ngColumns.html "joemc911" wrote in message ... I don't know if it's possible or at least I am not aware of how to do it, but I need to create a chart using days as the column, be it vertical or horizontal, and showing the hours covered by a schedule, basically saying on date X I covered 1000 to 1930 hours, hour format is no big deal, but I can't seem to make it work properly. It seems simple but I don't know excel well enough to figure it out. I would like to be able to do this for a monthly period. Any suggestions would be greatly appreciated. What I get now is either I get the date compared to hours or I get the dates removed and replaced with numbers of the column rather than correct date. I have hours in both actual hourly format and in general 4 digit representation. It doesn't matter which way it needs to be, I can change that as necessary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a pie chart | Charts and Charting in Excel | |||
creating an x,y chart | Charts and Charting in Excel | |||
Creating a dynamic chart | Charts and Charting in Excel | |||
Creating a chart with values from two columns | Charts and Charting in Excel | |||
Creating an x,y coordinate chart | Charts and Charting in Excel |