Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to make a graph showing quarterly totals for a spread sheet of income
for one year. How do i type in the formula that will show the 4 values. Thanks. |
#2
![]() |
|||
|
|||
![]()
You could create a pivot table to summarize the data, group the dates by
Quarters, and create a chart from the pivot table results. There are instructions for pivot tables in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm There are instructions here for grouping the data: http://www.contextures.com/xlPivot07.html Davko wrote: I need to make a graph showing quarterly totals for a spread sheet of income for one year. How do i type in the formula that will show the 4 values. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
2 graphs on 1 single chart cheet | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |