Good afternoon,
I've been watching my credit score fluctuate a lot more than what it seems it should for the past couple of years and I've decided to graph out my spending to see the correlation between credit card usage and credit score. It was easy enough to plot a line chart for historical data scores (as shown in the attachment), but that's as far as I can get. I've been working with line & bar charts using all of my credit cards data, but I think have way more data (1,500 rows) than I know what to do with. As an example, a credit change occurs on a day where I had several transactions so more data than what's needed is populated since it was matched using a vlookup (see below)
In my mind, I was thinking of a bar chart where the balance is shown per month, or better yet, per week per month, and the credit score for that week (when applicable) is overlaid on the bar along with the date and the change (+3, -3, etc...) if there is one. And then (as a bonus) clicking on the credit score or change label would take me to that date in the raw data so I could review that months activity. Is all of this even possible with the raw data, or does the data somehow have to be massaged before it's useable? Is a bar chart a good option, or is a line chart a better way to look at this?
I've exported my credit card register from Quicken for the years 2021 - 2023, which gives me nearly 1500 rows of transactions (many dates have multiple transactions). I've also downloaded my credit scores that has 75 data points including the date, my (edited) score, and the change value, ie... +3, -4, etc.. (or blank if there's no change). I cleaned up the data so it's consistent, concatenated some data, and then did a VLOOKUP on the dates to bring the Credit Score data into the Quicken Export file.
I've attached a partial months worth of data to give an idea of what I'm working with, and a very rough example of what I'm trying to accomplish at the bottom.
Any direction, advice, and / or samples provided would be greatly appreciated!
David...
Bookmarks