I have two questions regarding charts in reports.
1. I have a chart with 5 different status categories. In the legend for the chart, items with zero values are not displayed. Is there a way to overide this and display the complete legend even if no value exist?
2. The categories for my chart vary daily. A chart may only have two of five status categories on one day then four the next. Is there a way to associate the color of the chart with the color given for each category? For example, lets say one day I have good (green) and bad (red). The next day maybe a bad (red) item becomes questionable (yellow). Is there a way to have the chart update itself by automatically making anything questionable yellow, instead of me have to go into the chart and provide the correct color manually?
Any help on either is is greatly appreciated.
Jim
1. I have a chart with 5 different status categories. In the legend for the chart, items with zero values are not displayed. Is there a way to overide this and display the complete legend even if no value exist?
2. The categories for my chart vary daily. A chart may only have two of five status categories on one day then four the next. Is there a way to associate the color of the chart with the color given for each category? For example, lets say one day I have good (green) and bad (red). The next day maybe a bad (red) item becomes questionable (yellow). Is there a way to have the chart update itself by automatically making anything questionable yellow, instead of me have to go into the chart and provide the correct color manually?
Any help on either is is greatly appreciated.
Jim
