Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

Ptah

(33,984 posts) Tue Dec 9, 2025, 02:09 PM Tuesday

I have a spreadsheet question. [View all]

I have been tracking my expenses for several years using Open Office Calc.
I believe it is similar to Excel.
I have a separate sheet for each month.
I would like to create a chart or sheet that shows the expenses for a particular line item.
For example, what are the costs over the years for the account TEP?

Thanks in advance for any suggestions.

10 replies

= new reply since forum marked as read

Highlight:

I have a spreadsheet question. [View all] Ptah Tuesday OP

Unix junkie here. usonian Tuesday #1

Export each monthly sheet as a CSV? Ptah Tuesday #2

"Separate Sheet for each month" usonian Tuesday #4

You can create a Lookup Table JoseBalow Tuesday #3

Thanks, JoseBalow. Ptah Tuesday #5

excel uses macros in visual basic rampartd Tuesday #6

I don't want to purchase (rent) Excel. Ptah Tuesday #7

understand fully rampartd Tuesday #8

What macro would you use in excel to create a sheet or chart? Ptah Tuesday #9

it wouldn't be much rampartd Tuesday #10