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.
Oh interesting! I got rid of the merged cells, inserted the chart again and... it worked. I merged the cells again after inserting (cause its what the task says) and merging now had no more impact on it
Excel204847 Great, but better to stay away from merged cells, when you are not forced to use them. They do more harm than good.