If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Secondary X axis
Greetings!
Is there a way to create a secondary X axis. I have data like below: Jul-04 Aug-04 Sep-04 Oct-04 Baseline 6,270 12,914 19,883 27,209 Forecast 6,270 12,914 19,883 26,876 Actual 6,257 12,705 19,469 26,521 Threshold Green Green Yellow Red The dates need to be in X axis and the Threshold (Green, Red, Yellow) needs to be in X axis correspomding to the date too. Any suggestions? Thanks much! |
#2
|
|||
|
|||
If you want both the date and the threshold to be on the same side of
the graph, there is no need for a secondary axis. Suppose the dates are in row 1 (with Jul-04 in B1). Then, insert a new row at row 2. In the new B2 enter the formula =B1&CHAR(10)&B6. Copy to C2:E2. Plot A2:E5. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Greetings! Is there a way to create a secondary X axis. I have data like below: Jul-04 Aug-04 Sep-04 Oct-04 Baseline 6,270 12,914 19,883 27,209 Forecast 6,270 12,914 19,883 26,876 Actual 6,257 12,705 19,469 26,521 Threshold Green Green Yellow Red The dates need to be in X axis and the Threshold (Green, Red, Yellow) needs to be in X axis correspomding to the date too. Any suggestions? Thanks much! |
#3
|
|||
|
|||
Thank you so very much Tushar. I tried, the date turned to a serial number
like "38169 Green". How can I keep the date in date format? Thanks. "Tushar Mehta" wrote: If you want both the date and the threshold to be on the same side of the graph, there is no need for a secondary axis. Suppose the dates are in row 1 (with Jul-04 in B1). Then, insert a new row at row 2. In the new B2 enter the formula =B1&CHAR(10)&B6. Copy to C2:E2. Plot A2:E5. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Greetings! Is there a way to create a secondary X axis. I have data like below: Jul-04 Aug-04 Sep-04 Oct-04 Baseline 6,270 12,914 19,883 27,209 Forecast 6,270 12,914 19,883 26,876 Actual 6,257 12,705 19,469 26,521 Threshold Green Green Yellow Red The dates need to be in X axis and the Threshold (Green, Red, Yellow) needs to be in X axis correspomding to the date too. Any suggestions? Thanks much! |
#5
|
|||
|
|||
Thank you so much. You are so smart!!
"Tushar Mehta" wrote: Oops, sorry about that. In my test, I didn't even look at line 1, only checked if line 2 appeared correctly. Use =TEXT(B1,"dd-mmm-yy")&CHAR(10)&B6 Change the TEXT function's 2nd argument as desired. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Thank you so very much Tushar. I tried, the date turned to a serial number like "38169 Green". How can I keep the date in date format? Thanks. "Tushar Mehta" wrote: If you want both the date and the threshold to be on the same side of the graph, there is no need for a secondary axis. Suppose the dates are in row 1 (with Jul-04 in B1). Then, insert a new row at row 2. In the new B2 enter the formula =B1&CHAR(10)&B6. Copy to C2:E2. Plot A2:E5. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Greetings! Is there a way to create a secondary X axis. I have data like below: Jul-04 Aug-04 Sep-04 Oct-04 Baseline 6,270 12,914 19,883 27,209 Forecast 6,270 12,914 19,883 26,876 Actual 6,257 12,705 19,469 26,521 Threshold Green Green Yellow Red The dates need to be in X axis and the Threshold (Green, Red, Yellow) needs to be in X axis correspomding to the date too. Any suggestions? Thanks much! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
How do I set permanent secondary axis in PivotTable chart? | Microlong | Charts and Charting | 3 | January 8th, 2005 03:54 AM |
Problem with secondary y axis | Leslie | Charts and Charting | 1 | April 26th, 2004 12:38 AM |
Secondary Y Axis in Ms.Excel | Basix | Charts and Charting | 1 | October 1st, 2003 07:35 PM |