View Full Version : Bar chart with selected columns
Hi,
We've got a report with multiple columns.
We need to have a bar chart with values from only two of those columns
Is that possible? How?
More on https://support.dataaccess.com/Forums/showthread.php?65860-Chhose-columan-for-a-graph
TIA
Pepe
Bob Cergol
10-Jul-2020, 04:41 PM
Hi Pepe,
Did the information found in the other forum thread you referenced here not work for you?
Here's a snippet from the released docs that repeats that information:
Build 6.4.46
You can set specific colorcodes on the charts using @chartcolor:colorcode in the grouping text. The @chartcolor:colorcode will not show on the list.
Use @chartcolor:hide to hide a total from being used in a chart.
To be clear you caption the column to include the mentioned string. It will suppress that total from the chart, and the string will also be stripped out of the actual title displayed in the report grid.
For example: Total_Cost@chartcolor:hide will be captioned Total_Cost in the report grid, and that total will be excluded from the chart.
Bob
Pepe
14-Jul-2020, 08:49 AM
Thanks Bob.
More than colors or aesthetics the idea was to be able to represent the charts only with determined columns specified at programming time.
Salu2
Pepe
Bob Cergol
14-Jul-2020, 08:53 AM
Right, and you noticed that the "color" specified was "hide" which will hide that total from the chart.
Bob
Pepe
14-Jul-2020, 08:55 AM
Uuups. I missed that!
Sorry I will try it out
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.