Hi,
Does anyone know if its possible to add a trendline over a bar chart in App10? If so, how please?
Solved
Trendline on Bar Chart
+4Best answer by L-PINTA
It is not possible to combine bar chart and line chart in the standard way.
However, there's a workaround :-)
Create a bar chart element. Create a line chart element. Then, export the lobby page to XML. Manually edit the XML so that the line chart is in the same position as the bar chart. Import the XML back into IFS.
You will need to fiddle a bit with the data source for the line chart and also adjust the transparency of the line chart. But it is possible :-)
Hi
I did think this was possible but then found that you can only get a regression line on a line graph and not a bar graph. I did take a quick look to see if anyone else has had some luck and maybe use a dual axis graph but the following post suggests that there is no option for this in IFS10 Is possible in IFS 10, dual axis graph with bar with line chart in Lobby? | IFS Community.
Kind Regards,
Dan
+3It is not possible to combine bar chart and line chart in the standard way.
However, there's a workaround :-)
Create a bar chart element. Create a line chart element. Then, export the lobby page to XML. Manually edit the XML so that the line chart is in the same position as the bar chart. Import the XML back into IFS.
You will need to fiddle a bit with the data source for the line chart and also adjust the transparency of the line chart. But it is possible :-)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.