Help with charting annual and daily time-series

Question

Hi,&nbsp;&nbsp;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?&nbsp;&nbsp;The line chart should have a daily frequency, while the bar chart should have an annual frequency.&nbsp;&nbsp;The x-axis should have an annual frequency.&nbsp;Can provide data if needed.Thanks,Markus

hansvogelaar · Answer

Markus_Olsson&nbsp;
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?

markus_olsson · Answer

Dropping some sample data tomorrow morning :)!

markus_olsson · Answer

HansVogelaar

markus_olsson · Answer

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.

hansvogelaar · Answer

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

Forum Discussion

Help with charting annual and daily time-series

Share

Resources