Hi All
I have a data dump with 2 columns. Column A shows daily dates going back 5 years, Column B shows the price. In excel 2010 when i chart this it defaults to a bi montly view on the x axis. However I would like something like this https://alesandrab.files.wordpress.c...onal-chart.png where i can show the quarter and also year, looks alot cleaner.
How do i go about doing this? Do i need to create additional columns in the excel sheet showing quarter and year? Or can the excel chart do this for me automatically.
Thanks!
Bookmarks