During my webinar last week Xtreme Makeover, I showed a demo dashboard where a user could drill down from a pie chart down to a bar graph and pass the color from the selected slice to the chart below. This is a simple technique for creating consistency with color, which facilitates intuitive analysis; if it were only as simple to setup in Xcelsius… In essence, I am using chart alerts to dynamically change the color for a single series chart. This method will only work with bar and column charts.
Inside of my spreadsheet I associate a multiplier for each product line (1,2,3…). When I enable the pie chart drill down feature, I include this multiplier in my source data and data insertion range.
Directly under the insertion range where we link the bar chart’s data, I perform a simple calculation using the multiplier (=[value]/[target multiplier]). These rows highlighted in green within the spreadsheet are the bar chart alert targets.
Inside of the bar chart’s alerts tab, I color coded alert levels for each value in my pie chart.
With everything hooked up, you get a nice effect as someone clicks on the pie chart. What would be a better solution?…Having an ability to bind colors to the spreadsheet… As a user community you should definitely request this functionality on the BOBJ support and forum sites. With an ability to bind colors in the spreadsheet, you could enable this functionality for all components within Xcelsius, and in turn facilitate better analysis for end users.
……
Hi Mike,
Try posting this on the SDN forums at SDN.SAP.COM.
As for your question, it is not possible to set alerts in Xcelsius for a Pie Chart component. That renders this technique impossible for that item. Bothersome, no?
Thanks,
Brian
Thank you for your comments. With the PIE chart it does not make sense using alert colors. I would recommend using a bar or column chart if the intent is to chart values while indicating color-based alerts. This example was intended for scenarios where you want to assign a color to a dimension value. In this case you really need to do this assignment for dimensions that don’t change often so you can hardcode them.
It seems for this technique to work you need to know the category names at design time.
Will it work if the category names are not known at design time? Say you’re showing the top 5 items.
Thanks.
Hi Ryan!
I’d like to set alerts the way you showed, i.e. to change a color each time i select different slice of the pie. However i need to have in red the bars showing negative values, no matter what product it is. I put the alert conditions the following way:
1. Minimum – 0% for the negative
2. 0% – 101%
3. 101%…
the approach doesn’t work. As a result i see the negative color for the products with the threshold higher than 101%, while for the 0%-101% color doesn’t change.
What would you suggest?
Many thanks in advance!
Excellent Tutorial…
I have a very similar requirement. I’d like to change the pie chart slice color based on alerts. This may seem strange since many of the slices may wind up the same color, but we’re going to use multiple overlayed pie charts to produce a “donut” chart.
Any thoughts?
Is there a way to explicitly display values on a pie chart? or any chart for that matter.
Instead of the user hovering over the pie to get the values, is it possible to show em there!?
Your place is valueble with a view me. Thanks!�
We still cannot quite assume that We could often be the staring at the important points positioned on your blog post. My in laws and i are sincerely thankful for your special generosity and then for giving me possibility pursue our chosen profession path. Published right information I bought of your web-site.
After representation whatsoever of your blogposts I moldiness say i pioneer this particularised one to generally be top nick. I mortal a weblog also and necessary to repost a few shear of your articles on my own diary tract. Should it be alright if I use this as daylong I private reference your web diary or create a incoming linkage to your article I procured the snipping from? If not I make and could not do it without having your tolerance . I hump collection starred this article to cheep and zynga calculate motivated for publication. Anyway revalue it either way!
After city whatever of your blogposts I staleness say i constitute this fact one to mostly be top snick. I hump a weblog also and want to repost a few shear of your articles on my own journal tract. Should it be alright if I use this as longish I own write your web journal or make a inward unite to your article I procured the snippet from? If not I see and could not do it without having your acceptance . I hit assemblage marked this article to sound and zynga chronicle willful for testimonial. Anyway appreciate it either way!
There are some captivating points in while in this article but I don�t cognizant of if I take in all of them center to heart. There is some validity but I longing take sermonize on appraisal until I look into it further. Permissible article , thanks and we necessitate more! Added to FeedBurner as successfully
Thanks for posting great page. I have just shared this on my facebook wall to let my buddies read and comment on your page
And now, the time has come, to have some fun, and share some money. You want to become rich and famous? Get more visitors to your website. If you want the search engines to love your site then you just need to get more visitors to your blog. Content is automatically added to your blog every time that someone leaves a comment. Of course, if you really want to ramp up your traffic then you need a boost. There are some great strategies out there for accomplishing this. I managed to stumble across a system that includes everything that you need to know about getting free traffic to your blog. This package includes tricks to use with classifieds, blogs, forums, social sites, article marketing, news networks, text links, video marketing and much more. I really don�t think that any web marketer should be without these tips and tricks. Even if you consider yourself to be an expert on getting free traffic, you will find some great information, tricks and tips in these strategies. If you really want to explode your website traffic then check this out
Some great article, it helped me very much!
Awesome deal. Thanks
Dynamic Xcelsius Chart Color Great goods from you, man. I’ve understand your stuff previous to and you’re just extremely magnificent. I actually like what you have acquired here, really like what you’re saying and the way in which you say it. You make it entertaining and you still take care of to keep it wise. I can not wait to read much more Dynamic Xcelsius Chart Color again from you. Thanks For Share .
109271 beers on the wall.
Hey people, great site I have found It very helpful & it’s helped me out so much
I hope to be able to contribute and guide other users like this chat board has helped me
Howdy everybody, charming website I find It incredibly accessible & it’s helped me out a lot
What’s Up everybody, nice website I find It positively accommodating & it’s helped me tons
You’ve some genuinely valuable information written here. Good job and keep posting superb stuff.
Thanks for this kind of tips I had been seeking all Search engines to come across it!
Hello there, Can I download your photo and usage that on my website?
I must show my thanks to you just for rescuing me from this trouble. After researching throughout the the net and getting proposals which were not beneficial, I believed my life was over. Living without the strategies to the difficulties you have sorted out all through this article content is a crucial case, as well as those that might have in a negative way affected my career if I hadn’t noticed the website. Your personal know-how and kindness in dealing with the whole thing was helpful. I am not sure what I would have done if I hadn’t come across such a thing like this. I can at this moment relish my future. Thank you so much for this impressive and amazing guide. I won’t think twice to refer your blog post to anyone who should have guidance about this problem.
Many thanks for this particular info I has been checking all Yahoo to come across it!
Thank you for this specific information I was basically browsing all Yahoo to be able to locate it!
I needed to write you the little note to help thank you over again for the breathtaking basics you’ve shared on this page. It is so surprisingly generous with you to allow unhampered exactly what a lot of people would’ve sold for an e-book to generate some bucks on their own, primarily given that you could have tried it if you considered necessary. The pointers in addition acted to become a easy way to be certain that the rest have the same keenness like my own to learn very much more concerning this problem. I am sure there are thousands of more fun opportunities in the future for individuals that looked at your blog post.
Hello there, Could I export this post image and make use of that on my personal blog?
Hiya, May I download your page snapshot and apply it on my own webpage?
very nice put up, i certainly love this website, carry on it
With everything which seems to be developing inside this subject matter, all your opinions are generally rather refreshing. On the other hand, I appologize, because I can not give credence to your whole idea, all be it exciting none the less. It appears to everybody that your commentary are not completely rationalized and in actuality you are generally your self not really completely convinced of your assertion. In any case I did take pleasure in reading through it.
Hey there would you mind letting me know which hosting company you’re working with? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you recommend a good web hosting provider at a honest price? Thanks, I appreciate it!
Do you have a fan page on Facebook? You can increase your blog visitors that way! Cheers!
Aw, this was a really nice post. In idea I would like to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and by no means seem to get something done.
Do you have a fan page on Facebook? You can increase your blog visitors that way! Cheers!
An impressive share, I simply given this onto a colleague who was doing a little analysis on this. And he the truth is bought me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading extra on this topic. If doable, as you grow to be expertise, would you mind updating your weblog with extra particulars? It is extremely helpful for me. Huge thumb up for this weblog put up!
Your Honua Kai Vacation resort & Club is the particular #1 resort in Northern Boasts and also the #2 holiday resort like Boasts : just at the rear of the Four Months inside To the south Maui that may run you four times just as much for you to lease and it is a third the size. The Honua Kai will be the most recent location in Boasts and is Thirty-five many years newer compared to virtually any resort upon Upper Boasts. The Honua Kai can be a condo-hotel each rental property is actually privately owned when the property owner just isn’t right now there your property is place into the rental pool. Out of all resorts about Boasts the actual Honua Kai can be a true property which is 5-star and on Ka’anapali Beach which is the #1 beach front within Maui. There is a website which adopts fantastic detail regarding the Honua Kai — Honua Kai Resort & Spa
I hope to be able to give something back and guide other people like this website has helped me
This is a good approach to what, for some, may be a controversial topic. Very well though out post. – Man – a figment of Gods imagination. – Mark Twain 1835 – 1910
Certainly I like your website, however you have to take a look at the spelling on several of your posts. Several of them are rife with spelling problems and I find it very troublesome to inform you. On the other hand I¡¯ll definitely come again again!Cheers!
Pretty impressive post. I just came across your site and wanted to say that I have really enjoyed reading your opinions. Any way Ill be subscribing to your feed and I hope you post again soon.
Here is a simple and easy way to get free xbox live codes and ways to earn points gold membership. It has been a long hard search but i finally found a site which provided me codes and i was able to earn points and gold membership. It wasnt an easy work since there are many websites out there all claiming this and that. But the truth is they are fake. Made anly to steal your account information and other valuable details. You should never give away you account information to any website offering free xbox live codes. First step is to be safe.
When I originally commented I clicked the ¡°Notify me when new comments are added¡± checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove people from that service? See ya!
Dynamic Xcelsius Chart Color Magnificent goods from you, man. I have understand your stuff previous to and you’re just extremely magnificent. I really like what you have acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still care for to keep it smart. I cant wait to read far more Dynamic Xcelsius Chart Color again from you. Thanks For Share .
Thanks for the write up! Also, I noticed that your RSS feeds aren¡¯t working. Could you take a look at that? BTW,Good blog!
Good morning, This is an outstanding write-up, and I can agree with what was written here. I will be back to check out the comments soon. Thanks
thanks for sharing your thoughts, I haven’t think of this before, keep posting mate!
Hi! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!
Have you ever considered publishing an e-book or guest authoring on other sites? I have a blog based upon on the same information you discuss and would really like to have you share some stories/information. I know my viewers would enjoy your work. If you’re even remotely interested, feel free to shoot me an e-mail.
Please let me know if you’re looking for a article writer for your blog. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d love to write some articles for your blog in exchange for a link back to mine. Please shoot me an email if interested. Thank you!
I’m really enjoying the theme/design of your weblog. Do you ever run into any web browser compatibility problems? A number of my blog readers have complained about my blog not operating correctly in Explorer but looks great in Firefox. Do you have any solutions to help fix this issue?
My spouse and I absolutely love your blog and find nearly all of your post’s to be exactly I’m looking for. Would you offer guest writers to write content for you personally? I wouldn’t mind composing a post or elaborating on a lot of the subjects you write in relation to here. Again, awesome blog!
Good day! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us beneficial information to work on. You have done a outstanding job!
Hmm is anyone else encountering problems with the pictures on this blog loading? I’m trying to find out if its a problem on my end or if it’s the blog. Any feed-back would be greatly appreciated.
It’s a shame you don’t have a donate button! I’d most certainly donate to this brilliant blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to brand new updates and will talk about this site with my Facebook group. Talk soon!
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why throw away your intelligence on just posting videos to your weblog when you could be giving us something enlightening to read?
It’s a pity you don’t have a donate button! I’d certainly donate to this superb blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will share this blog with my Facebook group. Talk soon!
Howdy! Do you know if they make any plugins to protect against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any tips?
I’m really enjoying the theme/design of your blog. Do you ever run into any web browser compatibility problems? A handful of my blog audience have complained about my blog not working correctly in Explorer but looks great in Opera. Do you have any advice to help fix this issue?
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something informative to read?
The other day, while I was at work, my sister stole my iphone and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is totally off topic but I had to share it with someone!
Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your weblog? My website is in the very same niche as yours and my visitors would certainly benefit from a lot of the information you provide here. Please let me know if this okay with you. Appreciate it!
Hi this is kind of of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get advice from someone with experience. Any help would be enormously appreciated!
It’s a shame you don’t have a donate button! I’d most certainly donate to this superb blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to fresh updates and will share this site with my Facebook group. Chat soon!
First of all I want to say wonderful blog! I had a quick question that I’d like to ask if you do not mind. I was interested to find out how you center yourself and clear your head prior to writing. I have had difficulty clearing my mind in getting my ideas out there. I do enjoy writing however it just seems like the first 10 to 15 minutes tend to be wasted just trying to figure out how to begin. Any ideas or hints? Thanks!
Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.
This really answered my problem, thanks!
Spot on with this write-up, I really think this web site wants much more consideration. I’ll in all probability be once more to read much more, thanks for that info.
Hello, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam feedback? If so how do you prevent it, any plugin or anything you can advise? I get so much lately it’s driving me crazy so any support is very much appreciated.
Thanks for sharing excellent information. Your web site is so cool. I’m impressed by the info that you have on this site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles.
Yesterday, while I was at work, my cousin stole my iphone and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is totally off topic but I had to share it with someone!
Excellent goods from you, man. I have understand your stuff previous to and you are just too magnificent. I really like what you’ve acquired here, really like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I can not wait to read much more from you. This is actually a wonderful website.
I’m not sure why but this weblog is loading extremely slow for me. Is anyone else having this issue or is it a issue on my end? I’ll check back later on and see if the problem still exists.
Interesting blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. Many thanks
I came across your blog’s link put up by a friend of mine on Facebook. Thank you for putting useful information on the web. It’s hard to find this stuff nowadays.
Hello there! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog post or vice-versa? My site goes over a lot of the same subjects as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail. I look forward to hearing from you! Excellent blog by the way!
With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My site has a lot of completely unique content I’ve either written myself or outsourced but it looks like a lot of it is popping it up all over the web without my permission. Do you know any methods to help stop content from being ripped off? I’d definitely appreciate it.
Howdy! Someone in my Myspace group shared this site with us so I came to give it a look. I’m definitely loving the information. I’m bookmarking and will be tweeting this to my followers! Outstanding blog and fantastic style and design.
What I find troublesome is to find a blog that can inthraul me for a minute however your blog is different. Congradulations.
It is really hard to find a blog that can capture me for a minute but your blog is different. Great!
while using how to make simple the sun’s heating system you have ample water for your personal house
Thanks for the write up! Also, I noticed that your RSS feeds aren¡¯t working. Could you take a look at that? BTW,Great blog!
What I find troublesome is to find a site that can captivate me for a minute however your site is different. Well Done.
Dynamic Xcelsius Chart Color Fantastic goods from you, man. I’ve understand your stuff previous to and you’re just extremely fantastic. I really like what you have acquired here, really like what you’re stating and the way in which you say it. You make it enjoyable and you still take care of to keep it wise. I can not wait to read much more Dynamic Xcelsius Chart Color again from you. Thanks For Share .
WOW THanks!
Normally I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thanks, very nice post.
Hello, i think that i saw you visited my web site thus i came to “return the favor”.I’m trying to find things to improve my website!I suppose its ok to use some of your ideas!!
Magnificent beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept
Thanks for the write up! Also, I noticed that your RSS feeds aren¡¯t working. Could you take a look at that? BTW,Good blog!
E ‘straordinario incontrare un professionista esperto, per i quali potrebbe essere necessario un numero di affidabilità. Nella settimana oggi arena, semplicemente non è onestamente piace si espone a molte persone la risposta subjecttopic questo particolare. Proprio come fortuito devo trovare davvero scoperto un sito web in modo eccezionale come questo. E ‘gente come voi esattamente che sviluppano un grande miglioramento in questi giorni durante l’intera metodi di queste aziende guardare.
We are a group of volunteers and starting a new project in our neighborhood. Your site provided us with valuable information to work on|.You have done an impressive job!
Never gave it too much thougt. But I like the blog design. Will definitely come back for more. Nice!
video recording, do you do make your mind up to do it a few It is a little credit for your stuff our stuff just what you think
Never gave it too much thougt. But I like the blog design. Will definitely come back for more. Great!
I want to show my love for your generosity in support of folks that have the need for help on in this topic. Your very own commitment to getting the message up and down appears to be definitely advantageous and have without exception enabled somebody just like me to reach their endeavors. Your personal warm and helpful guide signifies this much a person like me and a whole lot more to my colleagues. Many thanks; from everyone of us
Thank You!, Phentermine, >:P, Xanax, 229, Tramadol, 68331, Buy Ativan, bjqd, Buy Cialis, gnu,
thanks for sharing your thoughts, I haven’t think of this before, keep posting mate!
Hi there could I quote some of the information here in this entry if I link back to you?
Strange this post is totaly irrelevant to the search query I entered in google but it was listed on the first page. The difference between the right word and almost the right word is the difference between lightning and the lightning bug. Mark Twain 1835 1910
When I originally commented I clicked the ¡°Notify me when new comments are added¡± checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove people from that service? Cheers!
Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your weblog? My website is in the exact same area of interest as yours and my users would definitely benefit from some of the information you provide here. Please let me know if this alright with you. Thanks!
I just added this site to my feed reader, great stuff. Can not get enough!
This is very interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your excellent post. Also, I have shared your website in my social networks!
I really like your wp design, exactly where did you down load it through?
Someone shared this in another blog? Came to pay a vist. Great one!
wow
I just added this weblog to my google reader, great stuff. Can not get enough!
Music began playing when I opened up this blog, so irritating!
Audio started playing when I opened up this site, so irritating!
First of all I want to say fantastic blog! I had a quick question that I’d like to ask if you don’t mind. I was interested to find out how you center yourself and clear your thoughts before writing. I’ve had trouble clearing my thoughts in getting my thoughts out there. I truly do enjoy writing but it just seems like the first 10 to 15 minutes tend to be lost just trying to figure out how to begin. Any ideas or hints? Many thanks!
I believe one of your adverts caused my browser to resize, you may well want to put that on your blacklist.
http://www.permanentmakeupexperts.com/permanent-makeup/Permanent-Makeup-Pomona/ Permanent Makeup Pomona %website
You have some interesting thoughts on this issue and I enjoyed perusing Dynamic Xcelsius Chart Color very much. After finding your blog on Digg, I have placed it in my bookmarks in order to share it with others.
I’m very happy to read this. This is the type of manual that needs to be given and not the accidental misinformation that is at the other blogs. Appreciate your sharing this best doc.
Salut a tous Selon moi les arguments de ce petit topic demandent de nouvelles valeurs! Votre idée parait recevable cependant je ne defend pas les différents avis ci dessus. Vous pourriez rajouter plus de valeurs pour etre plus convaincant… Au plaisir de vous relire
Dont you have an facebook i like button on your website, or i just dont see it? Had want to click on it, but now i go for short time to the sea. Dont tell anybody, mate.
Grazie per aver reso un onesto tentativo di spiegarlo. Penso che troppo duro su di esso e vogliono sentirsi dire di più. Se è OK, hai raggiunto la conoscenza più ampia, è possibile atteggiamento tra più messaggi come questo con maggiori informazioni? Questo è molto utile e vantaggioso per me ei miei colleghi
I think the environment should be put in the category of our national security
Howdy intelligent points.. now why didn’t I think of these?
I like your blog details! Undoubtedly an prime supply of data that is extraordinarily helpful. Cheers.
I regard something really interesting about your blog so I saved to fav.
Hello folks, I was simply checking out this weblog and I really appreciate the basis of the article, great job.
I found this post very informative. It helps to think of new perspective. Thanks for the post.
Dreamweaver tutorial
You had a good content here. This help myself to motivate my students how useful are the graphs are in presentation.
Dreamweaver tutorial
You had a good content here. It helps myself to motivate my students the use of graphs with their presentations.
You have a clear picture of what you are saying here. I surely understand it well. Keep it up!
This page provides informative details which can be used for any reports.
Although I’m not an expert about this subject matter, I wanted to thank you for sharing this article to the reader, this would be helpful.
Nice write ups.
Very Intuitive indeed! thanks for the tip! bookmarked for reference
crosstrainer test und schneller abnehmen.
This is just another color palette. Whew! This is so nice.
your work is awesome, i appreciated it but i don’t any solution now… i will try to find out the solution of your problem as soon as and will back to you..
The post was really nice.The analysis was really very good.
I think this is one of the most vital info for me. And i am glad reading your article. But want to remark on few general things, The site style is perfect, the articles is really nice : D. Good job, cheers