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
|
|||
|
|||
Chart Axis Value
I am using a line chart, where the chart results are driven by a validation list. So when I choose a specific product, up come sales, forecast and ajusted forecast for the product. Seeing that we are not living in a perfect world, the acuals differs quite by a huge amount depending on the product. What I want to achieve is to set the Major Axis (Y Axis) value to 20 % or a fifth of the total value, as I want only 5 gridlines in my charts. I have linked my Chart Title a to a cell (Validation Cell, so chart title = product name), but I cant seem to ink the Y axis major value to a cell. Is this possible, if so, is there somebody who can assist me with my request. Thanks to ever is willing to lookat this request. Thiem -- Thiem ------------------------------------------------------------------------ Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474 View this thread: http://www.excelforum.com/showthread...hreadid=480999 |
#2
|
|||
|
|||
Chart Axis Value
Thiem -
This is not a native Excel capability, but you can use VBA to achieve the same effect: http://peltiertech.com/Excel/Charts/...nkToSheet.html Near the top of the article is a link to an add-in by Tushar Mehta that handles it for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Thiem wrote: I am using a line chart, where the chart results are driven by a validation list. So when I choose a specific product, up come sales, forecast and ajusted forecast for the product. Seeing that we are not living in a perfect world, the acuals differs quite by a huge amount depending on the product. What I want to achieve is to set the Major Axis (Y Axis) value to 20 % or a fifth of the total value, as I want only 5 gridlines in my charts. I have linked my Chart Title a to a cell (Validation Cell, so chart title = product name), but I cant seem to ink the Y axis major value to a cell. Is this possible, if so, is there somebody who can assist me with my request. Thanks to ever is willing to lookat this request. Thiem |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
Second X axis at top of chart? | Phil Hageman | Charts and Charting | 1 | December 29th, 2004 01:48 PM |
Clustered Column Chart with Second Axis | Jon Peltier | Charts and Charting | 0 | April 10th, 2004 04:56 AM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |