• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change currency of Project Portfolio Dashboard

Luke M

Excel Ninja
Hi Sirac,
I've moved your thread to "Questions about Chandoo.org Products", to highlight to @r1c1 and @vijaySharma that you need help. I would guess that you need to change the cells' formats, but am only guessing. Hopefully someone else can give you better info.
 

Sirac

New Member
Thanks Luke,

I have changed the cell formats but this doesn't change the values on the dashboard unfortunately.

@r1c1 and @vijaySharma I look forward to your responses!

Best regards,

Sirac
 

Luke M

Excel Ninja
On the dashboard, can you tell how the values are being displayed? Are the numbers inside cells, or is it a shape/object that is displaying the number?
If the latter, we may need to find the formula that is generating the text. SHould be able to trace that back...if it's a named range, consult the Named Range manager. Once you find the source, you should be able to change the formatting there. THat's my best guess, at least.
 

Luke M

Excel Ninja
@Somendra Misra
You're ninja sword not sharp enough yet to slice through XL passwords? :p

@Sirac,
My initial guess was correct. After unlocking the workbook/sheet passwords, I was able to click on one of the shapes
upload_2014-8-13_8-36-15.png
You can see that it's pointing to the Calculations sheet. But wait! We can't see that sheet. Assuming that in the full version that you can unhide this sheet from VB, as it's set to "very hidden". If not, after unprotecting the workbook, open the visual basic editor (VBE) using Alt+F11. Hit Ctrl+g to bring up Immediate window. In the window, type this, then hit enter.
Worksheets("Calculations").Visible = True

Voila! You can now change the cells that were being references. The formulas currently look something like:
=TEXT(D11,"$ #,")&"k"

You can change them to use desired symbol, like:
=TEXT(D11,"£ #,")&"k"

Now our dashboard looks like desired layout
upload_2014-8-13_8-44-45.png

NOTE: Not sure what sort of licenses/agreements Chandoo has setup on his products. Modifying the Calculations tab could be a "do at your own risk". Simply providing the instructions to do as you requested. There, that's enough legal mumbo jumbo. :p
 
Top