• 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

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.
 
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
 
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.
 
Thanks Luke,

Here is the trail version, when I change the currency on the full version under the project details and project plans tabs to £ it does not change in the dashboard.

Its a shape / object which displays the values.

Best regards

Sirac
 

Attachments

  • Copy of project-portfolio-dashboard-VBA-v1-2010-trial.xlsm
    529.6 KB · Views: 17
@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
 
Back
Top