• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

Need to convert 3 columns of data to table to make surface chart

Hello experts, I have a large file of raw data... basically 3 columns of data - an X and a Y inputs, and a Z output... looking like this:

20	20	6
20	50	5.99
20	80	6.02
20	110	6.07
20	140	6.12
20	170	6.26
20	200	6.31
20	230	6.34
20	260	6.37
20	290	6.41
50	20	4.1
50	50	4.08
50	80	4.07
50	110	4.1
50	140	4.16
50	170	4.22
50	200	4.22
50	230	4.22
50	260	4.22
50	290	4.24
80	20	5.77
80	50	5.75
80	80	5.74
80	110	5.76
80	140	5.83
80	170	5.88
80	200	5.92
80	230	5.92
80	260	5.94
80	290	5.95
110	20	5.81

Open in new window


The 1st and 2nd columns of data both vary from 20 to 290 in increments of 30. The 3rd value is the corresponding "Z" value. My goal is to make a 3-D surface chart of these values.  Not knowing anything about Excel Pivottables, I started fooling with that and managed to get *very* close to what I want - see attachment "ExcelSheet.jpg". Only thing slightly messing up my nice chart is the fact that it blanks out the value where I have circled in red. As you can see from my raw data, that value should be 6. I can't figure out a way to "manually" put that value back in the table. Then my chart would be perfect.
   Also, crudely pointed at in green at the right of my screenshot, it notes one of the fields is "202". Where did it get that from? Lastly, circled in blue at the bottom right, it shows under "Values", "Sum of 6". I suspect this is why my one piece of data is missing in my final table... but I just don't understand why it did these several "weird" things.

Thanks!
   Shawn
ExcelSheet.jpg
0
shawn857
Asked:
shawn857
  • 4
  • 4
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
looking at the pivot table in your image, I see "Sum of 6" indicating that it is using the first row as labels, not data. Try adding a row above the data with labels to include in the pivot table range
0
 
shawn857Author Commented:
That was exactly it, thank you! I notice there is a thing called a "PivotChart" too - would this save me a step?

Thanks!
   Shawn
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome

> "PivotChart... would this save me a step?"
without knowing more about your process, all I can suggest is to try it ...
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
shawn857Author Commented:
Well, I simply want to make the 3d surface chart from my columns of data. Would the PivotChart do everything all at once - make the table AND chart? I'll give it a try....

Thanks
   Shawn
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome, Shawn -- please let us know
0
 
shawn857Author Commented:
Yeah, doesn't seem to do what I want, I will stick with the PivotTable, then making the chart from that... excellent!

Thanks
   Shawn
0
 
shawn857Author Commented:
Thanks!
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome, Shawn ~ happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now