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

(34,095 posts) Tue Dec 9, 2025, 03:09 PM Dec 2025

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 Dec 2025 OP

Unix junkie here. usonian Dec 2025 #1

Export each monthly sheet as a CSV? Ptah Dec 2025 #2

"Separate Sheet for each month" usonian Dec 2025 #4

You can create a Lookup Table JoseBalow Dec 2025 #3

Thanks, JoseBalow. Ptah Dec 2025 #5

excel uses macros in visual basic rampartd Dec 2025 #6

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

understand fully rampartd Dec 2025 #8

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

it wouldn't be much rampartd Dec 2025 #10