Forum Discussion
Line and Clustered Column Chart
Hi.
I am currently using the Line and Cluster Column chart within one of my reports (see below). Ideally I want the Line element of this chart to show discrete values only and not a continous line.
For each grouping in the chart (can be seen by the green/black/red bars) on the second Y-axis I want to plot a discrete value so effectivly only one plot per grouping. This chart joins the discrete points into a line.
I aprreciate that this chart is designed to work this way, does anyone know of any other available visuals which would allow me to do what I want?
7 Replies
Not aware of one. You will probably have to do some kind of R visual to get what you want.
Hi dax_bee,
>>For each grouping in the chart (can be seen by the green/black/red bars) on the second Y-axis I want to plot a discrete value so effectivly only one plot per grouping. This chart joins the discrete points into a line.
Did you want to switch the same color bar to one group, right?
If this is a case, you can try to exchange the Shared axis and Column series fields of "line and clustered column chart".
Regards,
Xiaoxin Sheng
Hi Xiaoxin
Ideally I am looking for a chart which will generate the following. The line being replaced by discrete points (in this example triangles)
Hi dax_bee,
>> The line being replaced by discrete points (in this example triangles)
I think the issue may related to your formula which store on the line value, it not appeared on my side.
Regards,
Xiaoxin Sheng
