Help with charting annual and daily time-series

Copper Contributor

Hi, 

 

Does anybody know if creating a chart where daily time-series data is plotted as a line together with annual data times-series data as columns is possible? 

 

The line chart should have a daily frequency, while the bar chart should have an annual frequency. 

 

The x-axis should have an annual frequency. 

Can provide data if needed.

Thanks,

Markus

5 Replies

@Markus_Olsson 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Dropping some sample data tomorrow morning :)!
Right now the plot is using the annual data but the idea is to use the daily data off to the right for the share price.

@Markus_Olsson 

Thanks, Does the attached version do what you want? The Daily Data series is plotted on the secondary x-axis and secondary y-axis.