Forum Discussion
Changing Target Value in SPC Graph
Good afternoon,
I have a graph built using this SPC Chart (1.5.1.0)...
The Lines get generated automatically across the graph, and I was wondering if its possible to change the Target Line (%) from its current 99.52% to another figure (%). The Target line properties can be manipulated here:
Or will I need to add an additional line and make that one as the % that I want to compare against ?
Kind Regards
Hi F_Reh
In this visual, the target value is determined automatically. As you can see in the tooltip, your target will be labeled as "Centerline". You can rename it in the "Tooltip Label" settings—for example, to "Target"—or use conditional formatting under certain conditions to display a custom label in the tooltip.
Tooltip Label = "Target (" & SELECTEDVALUE(gtt_by_month[month]) & ")"Therefore, if you want to visually represent a custom target value with a line, you won’t be able to do so directly. You can only choose whether to display this line or not.
However, I’d like to highlight the "Value Prefix" setting, where you can:
Manually enter text to appear before the automatically calculated value (e.g., "Target: [auto-calculated value]").
Use a formula to dynamically generate the prefix.
Perhaps these settings will be useful to you for your purposes
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
1 Reply
Hi F_Reh
In this visual, the target value is determined automatically. As you can see in the tooltip, your target will be labeled as "Centerline". You can rename it in the "Tooltip Label" settings—for example, to "Target"—or use conditional formatting under certain conditions to display a custom label in the tooltip.
Tooltip Label = "Target (" & SELECTEDVALUE(gtt_by_month[month]) & ")"Therefore, if you want to visually represent a custom target value with a line, you won’t be able to do so directly. You can only choose whether to display this line or not.
However, I’d like to highlight the "Value Prefix" setting, where you can:
Manually enter text to appear before the automatically calculated value (e.g., "Target: [auto-calculated value]").
Use a formula to dynamically generate the prefix.
Perhaps these settings will be useful to you for your purposes
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.