Technology

How do you line graph in excel 2007 showing a particular type of weekly data?

Excel

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
Excel
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
Excel
Image by Terry Hassan
Spectators departing from the ExCeL Exhibition Centre, during the London 2012 Olympics.

ExCeL waterfront
Excel
Image by frankdasilva
ExCeL marina

Excel
Excel
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

 1,191 Posts 0 Comments 18745 Views

Leave a Reply

Your email address will not be published. Required fields are marked *