ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create a graph from a worksheet? (https://www.excelbanter.com/excel-worksheet-functions/243807-how-do-i-create-graph-worksheet.html)

drumz

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!

drumz

How do I create a graph from a worksheet?
 
It would be nice to be able to edit your post...

I was just thinking that I may eventually have a filed for eggs sold. So if
anyone gets around to it, I need to know how to add something later.

Thanhks!

drumz

How do I create a graph from a worksheet?
 
Very easy to figure out. Thanks for the h......


All times are GMT +1. The time now is 07:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com