View original (French)

Charts with merged cells

clem46 Posted messages 11 Status Member -  
Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   -
Hello,
I want to create a "bar" chart concerning merged cells, but it ends up showing very thin bars because instead of counting 2 cells, it counts 9...
How can I make the chart only count the 2 "merged" cells?

Thank you in advance

Have a great end of the week and a good weekend

2 answers

  1.
    Zisia Posted messages 6 Registration date   Status Member Last intervention  
     
    In my opinion, it's normal for him to take into account 9, because for him a cell = one data point, and since you have several merged cells into one, he relies on that

    So it would be better for you to remove the Merge

    Good luck
    0
  2. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
     
    Excel works with the rows of the table, not with individual cells.
    But you can also merge the cells in the first column to make them conform to the second column.
    Or you can modify the display settings of the bars by choosing a zero spacing: your thin bars will be adjacent.
    But note, somewhere clearly visible, that merged cells should be avoided as much as possible, unless the sheet is not intended for calculations, filters, sorting, searching, charts, or pivot tables...

    Best regards.

    --
    Retirement is great! Especially in the West Indies... :-)
    ☻ Raymond ♂
    0