Forum Discussion
Solved
Fix data table to fit diagram
Hey! Im sitting on the following problem: the diagram I created with the data from my table is supposed to look the same as in pic2. When selecting the data and pasting the diagram it looks l...
Excel204847 Get rid of the merged cells for the row and column headers. Then select A1 to F12 and insert the surface chart. The correct axis labels will now be used automatically. If you insist on keeping the merged cells, you need to set the axis and series labels manually in the "Select Data Source" pop-up window.
To change the chart title, click on it, type the desired title, then press Enter.
To change the labels of the y-axis, either change the values in C1:G1 to the desired text values, or click Select Data on the Chart Design tab of the ribbon, then edit each of the series in turn and change their Series Name - either type in the name or point to a cell that contains the name (such as Datenreihen1),