Chart & X Axis Coloring 1

[Knicks]

I have created a report that has no data source that has 6 charts embedded.

Each chart contains a question field that has a grouped count of the answers. I was able to simply copy and paste each chart and change the field in the underlying SQL. I was then able to simply make my own legend for all charts as the colored bars are the same for all. The problem is occassionally a question from a chart does not use all the answer options and then the color scheme gets messed up. Where there are only 3 answer types I can manually change the colors to my schematic, but in this situation I have 4 answer types and I can't manually get to the last option.

Does anyone have any suggestions. The answers are numeric and mostly use 5 answers

1 = strongly disagree
2 = disagree
3 = neutral
4 = agree
5 = strongly disagree

I just followed the default color scheme and did removed the legends as they only show the number and not the wording that I need. I then made my own corresponding legend.

 

[GingerR]

For that particular chart that you want to change the color scheme for: let's put in some of your "real" data into the datasheet of the chart design, then you'll "see" the last color/bar/column.

In the report design, right-click on the chart object and view the properties. Run the underlying query, and when you see the query results, select all and then copy the entire datasheet. now double-click the chart, and VIEW DATASHEET. Click in the upper-left corner (to Select All) and go PASTE. This will paste your data over the MS Access-generated template data. If there's a pop-up message about it not fitting in, just say YES or whatever. Of course it will still change as your data changes - this will just change the "template" data. Now you should be able to see all of your bars/columns.

Another idea which could take care of this for you, depending on your "answer options": Make one chart, shrink the Detail section to 1/6th of the page, use Page Setup to make two columns, and give the report a recordsource. Say the recordsource of the report returns unique QuestionID's. Put QuestionID in the Detail Section, then alter the chart's recordsource to have the criteria "Reports!ReportName!QuestionID". This way the columns/colors will always be the same. Again, it depends on what your "answers" are. Anyhow, something to play with some day if you feel like it.

Hope this helps--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Knicks]

Thanx both ideas sound good!