• 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.

Search results

  1. S

    Pivot Table Trouble

    Had to get someone to code this for me in VBA. If someone is having similar issues, I will happy to post the steps to resolve this.
  2. S

    Pivot Table Trouble

    Hi All, Hope everyone is doing well. Got another problem and I have exhausted all google searches. So calling upon excel gurus for help. I have a pivot table and I am trying to use the result in the pivot table to do calculations(calculations are not part of the pivot, just one input is...
  3. S

    ColorFunction

    You can do conditional format. Not sure if you have tried that already. I believe you can only specify four conditions in conditional formatting. You can definitely do more than 4 in VBA.
  4. S

    Pivot Table Drop Data here Option

    we are still stuck in the dark age. My firm uses ms 2003
  5. S

    In cell pie charts

    okay, sorry I think I had a panic attack so posted a question before I exhausted all options I knew. so tried pasting using object insert and it looks GREAT!!!
  6. S

    In cell pie charts

    omg guys serious SOS this time. So I put this great ppt together with lovely looking pie charts and then.......... I printed it, first all the pie charts were circles, then I tried copy pasting using what hui suggested and now they all our all big dots. Please help :(
  7. S

    Pivot Table Drop Data here Option

    Thanks for your response Hui. So I just did a filter one at a time, and got all the data into the buckets I needed However now I have a problem I have a lot of blank cells in my table, which I will have to delete :( tedious I am sure you will know this and it was also discussed by Chandu...
  8. S

    Pivot Table Drop Data here Option

    Hi all, Maybe I have exhausted my quota for the week, but hoping I could squeeze in another questions. For excel 2003, is there a way for pivot tables to just list the data in the "drop data Items here" area, rather than getting a count or sum. Let me know if you need me to be more clear...
  9. S

    In cell pie charts

    you are awesome. It worked. So now I have it in my fonts folder and pie charts are back! Thanks for your help! Hopefully I don't lose them.
  10. S

    In cell pie charts

    also, would like to mention that I tried restarting my computer and then downloaded the font, but same problem, no in cell pie charts :( Any advise on this would much appreciated. I think in cell pie charts are revolutionary and would really like to use them.
  11. S

    In cell pie charts

    Hi Hui, Thanks for your prompt response. Maybe I wasn't clear, but for some reason even the excel pie charts changed into weird symbols in the excel sheet, but I was hoping this wouldn't happen to ppt. I had used paste special, will use insert object next time. But I am not sure how to get...
  12. S

    In cell pie charts

    Hi, has anyone used in cell pie charts. I downloaded the practice sheet and everything was great. I even used some to paste in power point. But when I checked today the pie charts looked all weird. Can someone please advise as to what I am doing wrong. Thanks
  13. S

    Chart color link to data

    I think I know what you are looking. Correct me if I am wrong but you want a certain value or entity to get highlighted, regardless of where it falls on the graph. I am looking for something similar. Will let you know if I find how to do it.
  14. S

    Automatic Format Axis

    I have to do multiple graphs based on similar data, but each time I need to format the axis as I change the data but the graph uses same cell reference. I have to do like 400 such graphs. So changes in data requires me to format the y axis each time as the y axis stays the same as the last...
Back
Top