Should be simple, but I'm lost.
I have 12 sheets, one for each month. Each sheet has one text field that gives the date, as in "JAN10", and a second money field that shows how much I paid to store1.
I want to learn how to look at the yearly picture in two ways: one, as a graph plotting dollar amount points, dollars labeled on y axis, vs time, using the date-text field as the label for each point, along the x-axis, as JAN10, etc.
Second, I want to learn how to present the same data on a new sheet within same book, that lists all 12 entries of the same info for each of the 12 dates.
so far, i can make a bar graph by adding each point manually from each sheet. But how to I get the date-text field to identify each bar? It would help me to know how to add these date labels to this bar graph. Id like to think if I got this part ok, changing graph types would be easy.
That would leave how to assemble the 12 payments and respective dates onto one new sheet, as part of the same book.
I hope this can be automated to the extent that I won't have to manually extract the data from each sheet to add to the graph or new sheet.
I don't do macros yet, but cell programming seems to work ok for me.
If you can help, I'd be so grateful.
Thanks, seekertom
I have 12 sheets, one for each month. Each sheet has one text field that gives the date, as in "JAN10", and a second money field that shows how much I paid to store1.
I want to learn how to look at the yearly picture in two ways: one, as a graph plotting dollar amount points, dollars labeled on y axis, vs time, using the date-text field as the label for each point, along the x-axis, as JAN10, etc.
Second, I want to learn how to present the same data on a new sheet within same book, that lists all 12 entries of the same info for each of the 12 dates.
so far, i can make a bar graph by adding each point manually from each sheet. But how to I get the date-text field to identify each bar? It would help me to know how to add these date labels to this bar graph. Id like to think if I got this part ok, changing graph types would be easy.
That would leave how to assemble the 12 payments and respective dates onto one new sheet, as part of the same book.
I hope this can be automated to the extent that I won't have to manually extract the data from each sheet to add to the graph or new sheet.
I don't do macros yet, but cell programming seems to work ok for me.
If you can help, I'd be so grateful.
Thanks, seekertom
