Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

d surface chart

ResolvedVersion 2007

Hashim has attended:
Excel Intermediate course

3d Surface Chart

I have a 2 sets of data. Both use Time, Place and Amount.

I want to create a surface chart that will allow me to plot the data for Time, Place and Amount for the 2 sets of data. i.e it will show two surfaces on the chart. Currently, I can only do it for one set

Thanks

RE: 3d Surface Chart

Dear Hashim

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

I am not exactly sure about the question but what I have done is create a spreadsheet file with the variables that you mentioned in your post.

Please let me know if this is the result you were after. If not then please elaborate a bit more to let me know how your data looks!! I am sure that we can resolve this eventually :)

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Attached files...

surface chart.xls

Mon 16 Feb 2009: Automatically marked as resolved.

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.