jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 36
I have a worksheet that has 70,000+ rows of data across 30+ columns.
I'm trying to make a line graph to show trends from month to month.
Column F contains "Direct" or "Indirect"
Column S contains "Transaction Date"
Column U contains "total Hours"
Column V contains "reg hrs"
Column W contains "ot hrs"
I want to make a line graph showing the trends of Direct v Indirect hours over a period of time based on the transaction dates.
I would like the dates to be along the X-Axis
I would like hours along the Y-Axis
2 different lines for each, Direct v Indirect.
Appreciate any help!!
I'm trying to make a line graph to show trends from month to month.
Column F contains "Direct" or "Indirect"
Column S contains "Transaction Date"
Column U contains "total Hours"
Column V contains "reg hrs"
Column W contains "ot hrs"
I want to make a line graph showing the trends of Direct v Indirect hours over a period of time based on the transaction dates.
I would like the dates to be along the X-Axis
I would like hours along the Y-Axis
2 different lines for each, Direct v Indirect.
Appreciate any help!!