I have a bar chart with two measures, how can i display the axes label for both measures

[Alonso]

i have a survey data of multiple grades that were filled by eather the student, the techer or the parent.

i am showing the grade on the top axis and i want to show the parent/student/teacher measure on the bottom axis

 

[JWiseman · Accepted solution]

In this case, I would recommend creating a multicolumn / card style report...see below for the details. I can't attached a .zip or the file itself so I have sent it to you. If anyone else is looking to see how to create this type of report please feel free reach out to me.

The reason to use this type of report is that it will allow you a lot more flexibility in the chart formatting and more importantly allow you to add other survey objects at the class level; more info on that point further below.

Note that in the screenshot below all of the parent student teacher summaries are the same as there is an equal count for each.

• The report is grouped by year.
• The chart is contained in a subreport which is in the Group Header.
• The subreport is formatted as a multi-column report.
• The multi-column format is basically a "card" format.
• There is one card for each class and each card will have its own chart.
• See the Section Expert > Details section on the sizing.
• Right now the charts are showing the count of responses...this of course can be changed.
• Note that since each class has a card associated with it, you can add other objects such as cross-tabs, summaries, more charts etc. Those will also then be at the class level.
• You can of course add cross-tabs, summaries, charts at the group level and the report level as well.
• There is also a subreport in the report header which is used to find the maximum of all of the survey counts by year and class. This value is used to ensure that the scale for all of the charts in the entire report are the same. You can change this if you want the scale to be by year.

[Alonso · Accepted solution]

Thank you but the parent/student/teacher is still in the ledger...

[JWiseman · Accepted solution]

That's a text object. Please open the report and you'll see that you can move anything where you want. Anything you want to be repeated at the class level is in the subreport.

[Alonso · Accepted solution]

OK, it worked, Thanks!

[JWiseman]

Hi Alonso, one way to do this is to

1. create a new Formula that is only the number of the highest value...in the case of your chart would that be 50?
2. Next add that new formula as a Show Value to your chart. Depending on your chart that should now keep the scale the same for all 3 of your bar series.
3. Now right click on the bar representing the formula and choose Format and change the Fill colour to transparent.

If on step 2 you don't see that happening can you please show us a picture of the Chart Expert's Data tab.

[Alonso]

it doesn't allow a second value field

[JWiseman]

OK...can you post a csv with a sample of the data? I may be able to get you a workaround.

[Alonso]

the data is simple class name string measure type string ("parent", "student" or "teacher") and count of the Aliases

[JWiseman]

If you're trying to show the Class & Parent Student Teacher data on the bottom as well then you would create a single formula that appends those two and then use that in the Chart Expert. e.g. The new formula coud have syntax of {@class} + chr(10) + {@PCMeasureType}

If you then want to show the measure then right click on the chart and choose Chart Options > Data Labels > Show Data labels and there is a base of chart option.

[Alonso]

Well, Concatenating both measures works but it looks awful... any other ideas?

[JWiseman]

If you can post a .csv with some of the scrubbed data, via a Crystal Reports export to data only, then I can look into it. It's guesswork at times as to what might work or look less awful with the charting engine.

[ido_millet]

Deleted answer.