Forum Discussion

Excel204847's avatar
Excel204847
Copper Contributor
May 08, 2022
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...
excel
Excel on Mac
Formulas and Functions
Macros and VBA
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 08, 2022

    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.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 08, 2022

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.

 

Excel204847's avatar
Excel204847
Copper Contributor
May 08, 2022
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
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 08, 2022

    Excel204847 Great, but better to stay away from merged cells, when you are not forced to use them. They do more harm than good. 

Resources