d surface chart

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3d Surface Chart

3d Surface Chart

resolvedResolved · Low Priority · Version 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:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.