Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nasu
Yak Posting Veteran
50 Posts |
 Posted - 2010-03-24 : 11:38:49
|
| I have two pie charts on the same report. They get their data from the same dataset and both show the number of requirements with different status in different software development projects we are running.I have different filters in each chart (of course) to select the requirements applicable to a certain project.I have created a custom color palette but is there a way to map ceratin colors to certain values (slices) in the chart? What happens now is that one chart does not return any requirements with status "Draft" because of the filter it uses. This means colors will be totally different for the same value in the different charts since colors seem to be used in the order the different statuses appear in my dataset. And also, how can I make all possible values appear in the chart legend even if some of them do not show up in that particular chart? This is of course not as important as the first issue but it is usually interesting to know which all the possible values are when you look at a chart. |
|
|
|
|
|
Mapping Colors to Field Values