on 2009 Jan 26 9:11 PM
I am trying to build a combination chart that will allow me to turn the alerts on based on specific criteria, however the alerts appear to be disabled. Is that because it's a combo chart, or do I need to change a setting to enable it? Thanks!
Hi Chris,
I have done some basic testing and the combo chart allows alerting until you add a second series.So it only alerts when it is behaving as a column chart.
Regards
Alan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, it looks like I was able to figure out that the alerts were not causing the initialization problem. It appears that it was a combo effect. When I added a list view box that read off of vlookups, combined with the alert charts reading a different vlookup, it was causing the problem. When I deleted the list view box and replaced it with a spreadsheet table instead, it worked properly.
So for me, it's working now, but that does seem to be an error that should be corrected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's correct; having more than one series will disable the Alerts feature. The reason is that multiple series have to be recognized by a uniform color. The Alerts feature will color each data point an individual color, therefore making it difficult to identify if a red colored bar belonged to series 1 or series 2.
I tried to create a dynamic alert using a VLOOKUP function as well. However, this worked on my end. I have attached the sample XLF that I've created. Here were the settings that I've applied:
-Enable Alerts
-By Value
-Use a Range (Sheet1!D5:E5, which are both VLOOKUP functions)
-Enable Auto Colors
-Low values are good
Let me know if there any differences in your version. If the settings appear to be similar...then it could possibly be the nature of the VLOOKUP function.
Can you remove the alert and the link to the VLOOKUP, then use a spreadsheet table to link to the VLOOKUP function instead? This will help isolate the issue around the formula, instead of a combination with the Alert property. Let me know your results.
Best regards,
Jon Teopaco
Edited by: Jon Teopaco on Jan 27, 2009 9:11 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Now that I realize the combo alerts don't work when you add more then one series, I was able to get it to work, however, if I base the range of the alert on a formula, the program won't work. Basically I set an alert to a vlookup (also tried hlookup) formula. The idea is that the alert changes monthly so i want it to reflect which month I'm in. However, the minute I put the alert to a formula I can never get past the "initializing" on preview screen. And when I try to export it to another format, it freezes there too.
Any suggestions?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.