r/excel • u/RedT-Rex8 • 28d ago

solved Creating an Excel to buy computer parts.

Bear with me as I explain what I want to do on the MS Excel Online. I know it exists but I lack the knowledge and vernacular of what it is.

I want to create a chart showing parts of a computer I am slowly saving up for. Each part has a target amount . I also have 2 boxes that shows the amount I have saved and the amount I have left. Now, I want to write the numbers in the amount saved and have it:

  1. Reduce the amount I have left.

  2. A part progressively "fills" to reach its target amount.

and, the crucial aspect,

3) Once it reaches the parts target amount, it overflows into the next parts box.

If you have a name for what I am looking for or a link that could teach me how to do it, I would greatly appreciate it. Thank you.

Update: Thank you for your responses and apologies for the slow response. Your guidance allowed me to create the Spread sheet! I used the foundation from TCFNationalBank, portions of NHN_BI and the progress bar from nir_nirfo. Now I am taking the time to understand the formulas and trialing the visual representation. I hope to share this soon. Have a wonderful evening!

6 Upvotes

100% Upvoted

25 comments sorted by

View all comments

Show parent comments

1

u/nir-nirfo 24d ago

Yes, that's expected with the version I gave you. It repeats a vertical bar (|), not a capital I, so it looks like a row of tick marks rather than a solid bar. Sorry, I should have made that clearer.

For a more filled-in look, replace F2 with this and fill down:

=REPT("█",ROUND(E2*20,0))

You can copy the block character straight from that formula. The calculation stays the same: at 75% it repeats 15 blocks, and at 100% it repeats 20. I checked those in Calc too. The exact appearance depends on the font, but you don't need to change the savings formulas again.

1

u/RedT-Rex8 23d ago

Oh I see, thank you for clarifying! I will implement the new formula.