Forum Discussion
How to create a line chart which is both solid and dotted
Hello All, I have been given the task to create a line chart. The line chart will contain Actual and Predicted Values. The Forecasted/Predicted Values need to be represented by a dotted line while the actual values will have a solid line..I need to achieve this feature in a line graph..What do you recommend how i do it? There is something called Charticulator that I am not very much aware of? will that work for this or I can do it simply with another chart from the marketplace..Please help me here
Anonymous
In a line chart, add the Actual and Forecast sales,On the properties pabe, select the line and the Forecast measure, then change the line style to dotted
3 Replies
- Fowmy
Super User
Anonymous
In a line chart, add the Actual and Forecast sales,On the properties pabe, select the line and the Forecast measure, then change the line style to dotted
Thank you so much Fowmy for your solution. Your sol inspired me to create the below.
I created 2 measures where one is the Actual and the Other is Actual&Forecast.
In Actual&Forecast the logic is If Actual value not available then give me forecasted values.
The arrangement of the 2 measures is also important in the Y-axis field is also important. Keep Actual&Forecast on the top and then Actual values.
Then you get the following:
Hi Anonymous ,
Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.
Best Regards,
Stephen Tao