Forum Discussion

DataGeo's avatar
DataGeo
Icon for Helper I rankHelper 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.

     

DataGeo's avatar
DataGeo
Icon for Helper I rankHelper 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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the link from where i can download your workbook.