You can learn more about charts in our Excel - Level 2 training course. How do your Excel skills stack up?
Aug 29, Aug 08, Jul 19, May 29, Apr 04, Matthew is a qualified Microsoft Office Specialist, Microsoft Certified Applications Specialist and a Microsoft Certified Trainer with over 11 years of hands-on experience in a training facilitation role. He is one of New Horizons most dynamic instructors who consistently receives high feedback scores from students. Matt enjoys helping students achieve real professional and personal growth through the courses he delivers.
Set Location Please select your state: Incorrect username or password. Log out. Solutions for Matthew Goodall. Create a chart with a secondary axis in Excel Select it all and create a 3-D Cylinder chart.
Your result will be like this. It's missing labels, and 0,4,2. You can add the labels manually. You need to arrange the data in a 11 x 11 grid from 0 to 10 across and down. At the intersection of the X and Y values enter the Z value.
XonGrid is very flexible and easy to use.
Create a chart in Excel for Mac - Excel for Mac
Create a chart in Excel for Mac
I have a table of data as follows: Do you think it is realizable in Excel? SoftTimur SoftTimur 3 5 What happens when you select the data and then choose from the Insert Ribbon from the Chart section i. Line then 3D Line? That doesn't give a chart I want If you create a grid, X horizontally, Z vertically, you can type the Y values in the cells. Thanks for posting this, saves me from uploading a screenshot of my version.
SoftTimur, here you can see the drawbacks of a 3D chart in action.