How do i draw lines from each segment on the pipe chart and make the data static ..
Chart now shows data as pop up. but i want to draw lines from each segment and make data static instead of the data appearing only when you mouse over.
One way is to add a second expression of ="Country", and again select Values on Data Points. That would show 23% and then Asia on a second line. Not exactly what you want, but close. I thought maybe the dual() function would let you do it exactly, but it seems to display the number instead of the text.
Hmmm, I wonder why dual() isn't working for me, then. Oh, duh. I didn't notice that I was using "relative". Of course it won't work with relative. Removing that lets the dual() work, or I can calculate the relative value myself. Attached is doing it calculating the relative value myself.
