If you want those points only as symbols display them as ‘Scatter’ (i.e. Thus they will be treated as one set and can be connected (‘Scatter with straight line and marker’ or are you using trendlines? Doesn’t matter, same principle).Ģ) Add another ‘Data Series’ with just one of the two data sets and display in the diagram, too. We sorted it per email, but but I post the answer here again, so others may benefit from it:ġ) When you select the data for the diagram, mark the first set, then hold the Ctrl key and mark the second set.
This is the reply I wrote to Mark when his question came up a couple of weeks ago.
However, I hope there is also some fun involved in building it by your own, and of course some learning is always good.) (PS: I am planning to make the Excel spreadsheet available for downloading, but can currently not find the time to figure out how to do it. I hope that explains it and helps you to construct your own ternary diagram. As I understand you do not have problems with those steps. Thereafter (“Adding tick marks and …”), we simply mimic that style graphically for the other two axes. For instance I chose ‘Cross’, which means the tick marks cross the axis and you have the mark inside and outside. Here you can format the style of the ticks and numbers like in a ‘common’ XY-graph. The next step is to delete the Y-axis (“Cleaning up the Chart”). In Figure 12 you see that both, X and Y axes are visible. Remember, we ‘project’ a ternary diagram onto an XY-diagram/graph. It always helps to see where I can improve the description, as I am sure you are not the only one struggling with this.
0 kommentar(er)
