LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default How do I create a graph from a worksheet?

I'm starting to sell eggs from my chickens and want to track the amount of
eggs I get daily/monthly/yearly.
I made a graph a long time ago but am not sure where to start especially in
version 2007.

So I have a total of a column for each month in a cell and then a total for
the year adding those 12 cells for the year total.

So my first row is a header and the 2nd row contains the total cells for
each month with the year at the end. The dates are listed in separate columns.

I would like the graph to be in a separate worksheet (in the same workbook)
and each workbook will have to tabs for each year in a decade.

I hope I've provided enough information and greatly appreciate your
assistance.

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Charts and Charting in Excel 3 August 24th 06 07:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Discussion (Misc queries) 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet [email protected] Excel Worksheet Functions 2 August 24th 06 05:26 PM
plot graph from multiple worksheet as embedded chart object on every worksheet jeftiong New Users to Excel 0 August 23rd 06 01:50 PM
Can one still create a graph using data in the worksheet? mgpitner Excel Worksheet Functions 1 January 20th 05 04:35 PM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"