P
PD
Hi I want have my excel line charts updating automatically when new data is
added every quarter. I also want the x – axis display as e.g. 2008Q1 or Q1
dec – 2008. I have at the moment mmm-yyyy, so it is in date formula so it
updates automatically, however when a second axis e.g. Q1 is underneath it
either won’t allow me to update automatically or there will be a large amount
of blank space representing where I have chosen the source data to go to. So
is it possible to have two x –axis one date and one text or to have one x –
axis displaying date and text on charts that will automatically update? It
seems I can only have one or the other: date only and automatic update or no
automatic and display as I want
Thank you in advance
Simplified version provided below of layout. (Charts won't upload)
All Persons (Per Quarter) Q1 Q2 Q3 Q4 Q1 Q2 Q3
Dec-2005 Mar-2006 Jun-2006 Sep-2006 Dec-2007 Mar-2007 Jun-2007
State 4.2 4.3 4.8 4.1 4.2 4.5 4.7
Dublin 4.3 4.8 4.6 4.2 4.3 4.3 4.8
South East 5.9 5 5.8 4.8 4.6 5.1 4.8
Mid East 3.1 3.3 3.8 2.9 3.2 4.1 3.9
added every quarter. I also want the x – axis display as e.g. 2008Q1 or Q1
dec – 2008. I have at the moment mmm-yyyy, so it is in date formula so it
updates automatically, however when a second axis e.g. Q1 is underneath it
either won’t allow me to update automatically or there will be a large amount
of blank space representing where I have chosen the source data to go to. So
is it possible to have two x –axis one date and one text or to have one x –
axis displaying date and text on charts that will automatically update? It
seems I can only have one or the other: date only and automatic update or no
automatic and display as I want
Thank you in advance
Simplified version provided below of layout. (Charts won't upload)
All Persons (Per Quarter) Q1 Q2 Q3 Q4 Q1 Q2 Q3
Dec-2005 Mar-2006 Jun-2006 Sep-2006 Dec-2007 Mar-2007 Jun-2007
State 4.2 4.3 4.8 4.1 4.2 4.5 4.7
Dublin 4.3 4.8 4.6 4.2 4.3 4.3 4.8
South East 5.9 5 5.8 4.8 4.6 5.1 4.8
Mid East 3.1 3.3 3.8 2.9 3.2 4.1 3.9