How do you line graph in excel 2007 showing a particular type of weekly data?
I have an excel spreadsheet where there are 20-30 transactions a day with 10 or so different types of transaction types. I’d like to show in excel the weekly trends of a specific type of data. Any ideas?
Excel best answer:
Answer by Scrawny
You can list your transactions by date and transaction type and then produce a Scatter Chart from the data. Each transaction type would be charted as its own series which should make it relatively easy to see what was happening with each type of transaction.
You can also use Pivot tables and charts to summarize your data and to chart the summaries.
ExCel – weightlifting entrance
Image by diamond geezer
ExCel is very close to City Airport, and occasionally the roar of a plane muffles sound in the arenas.
ExCeL Exhibition Centre
Image by Terry Hassan
Spectators departing from the ExCeL Exhibition Centre, during the London 2012 Olympics.
Image by frankdasilva
Image by Lettuce.
Excel centre and bridge across Royal Victoria Dock, London
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development…
Excel Video Rating: 4 / 5