Forum Discussion

DataGeo's avatar
DataGeo
Helper I
8 years ago
Solved

Combination chart showing average rather than actual data values with combined dates

I've got 2 different excel sheets of data within the same time period, but one table is simply by year while the other has specific days within these years. Different date formats basically.   I am...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Share the link from where i can download your workbook.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may download my solution from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

What do the stack in the column chart represent?  What does the line depict?

  • DataGeo's avatar
    DataGeo
    Helper I
    8 years ago

    Hi Ashish,

     

    The stacked bars represent the donation amounts from the table, the line should represent the price in the other table. In the shown visualization of the combination the line is 'summed' and only showing a single value over the date range.