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...
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.
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!!!
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 :(
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...
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...
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.
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...
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
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.
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...