View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Chart with three variables


The download link didn't work. ("Invalid Attachment specified", whatever
that means.)


Jon, click on the "view this thread" link instead, and then click on
"Clipboard.jpg" from the page that comes up, or "example.zip" to download
the sample dataset.


I'm not going to open the data file, but I did look at the chart image.

I don't see how I can use the pivot table to create the graph. I've put
the data and a hand-made example for a part of the file as an attachment
to this message. I hope this gives a better understanding of what I
need.


It looks to me like what you're describing is a contour, or surface,
chart. Excel does those. You may then have to manually trace the contours
onto separate graphs if you wanted, but I can't see why you'd want to: the
contour chart shows them all elegantly in one.


I don't think it's a contour chart that the OP wants, I think it's a chart
with a whole set of trendlines. I can't see any way to do this without
making separate trendlines for each subset of the data. This means doing
what the OP didn't want to do: "sort the data manually on the third variable
and make a seperate serie of all data with the same third variable." I would
take this opportunity to learn how VBA might make one's life easier by
automatic the constructions of so many data series and trendlines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______