2

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.

enter image description here

1 Answer 1

2

No, it is not currently possible, and there isn't really a workaround.

You can try using 3d graphing sheets like this but it won't make a surface plot. You may be out of luck.

6
  • 2
    +1 for the interesting link, but there IS a workaround (just not using the graph tools), and that would be to use geometrical figures, that are available in all recent Excel versions. Aug 28, 2013 at 1:49
  • I suppose you could create VBA to generate a 3d surface chart automatically using shapes, but that solution is worse than the original problem!
    – jmac
    Aug 28, 2013 at 1:51
  • what I meant was for the OP to manually place a small filled circle in the position. And yes, the solution you said is worse. Barring use of other tools such as Gnuplot or Matplotlib I don't see how else to do this. Aug 28, 2013 at 2:21
  • Ah, yeah, that would actually be a very clever solution @Doktoro! Talk about me suggesting an overengineered solution!
    – jmac
    Aug 28, 2013 at 2:25
  • 1
    Using geometrical figures (in the sense of creating a program to map out 3d data using perspective to mimic the surface chart) is probably not realistic. It would be far easier to create a program to guesstimate where to plot the red dots you have there within the chart area if you are inclined to go the extra mile. At any rate, best of luck.
    – jmac
    Aug 28, 2013 at 6:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .