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
|
|||
|
|||
Category Axis placement
I have a stacked bar chart, with total values of the bars being negative or positive. Can I place the Category Axis (X-axis) at the bottom of the chart, without specifying a specific number? Now I have put a fixed number on the scale tab for the Value axis (Y) for "Cuts Category Axis (X) at". This is rather inconvenient as the minimum values can change from one run to another. -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=376715 |
#2
|
|||
|
|||
You could have an activate event macro, something like Private Sub Chart_Activate() ActiveChart.Axes(xlValue).ActiveChart.Axes(xlValue ).CrossesAt = Worksheets("Sheet1").Range("A1") End Sub Where Range A1 contains the figure you want the axis to cut through. A1 will have a formula like =MIN(A1:A10) This is just for you to get an idea. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=376715 |
#3
|
|||
|
|||
Pick an arbitrarily large negative number (larger than any legitimate
value you will possibly have) for the 'Category (X) axis crosses at' field. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a stacked bar chart, with total values of the bars being negative or positive. Can I place the Category Axis (X-axis) at the bottom of the chart, without specifying a specific number? Now I have put a fixed number on the scale tab for the Value axis (Y) for "Cuts Category Axis (X) at". This is rather inconvenient as the minimum values can change from one run to another. -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=376715 |
#4
|
|||
|
|||
The last reply was the "ideal" solution to my problem. As the Y-values do represent percentages growth or decline and the decline couldn't be more than 100%, there is an absolute minimum to the scale. The nice thing about the solution is that if the minimum data value is e.g. -40%, the Y-scale doesn't extend to -100%. Thanks. -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=376715 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I make the Y axis in an excel chart the category axis? | megnadoodle | Charts and Charting | 2 | March 29th, 2005 09:27 AM |
Hard carriage return in Category Axis Title? | E Harris | Charts and Charting | 4 | March 16th, 2004 07:47 PM |
X Axis Category Label not appearing | Janna | Charts and Charting | 0 | February 13th, 2004 09:41 PM |
Category axis problem | Giel Weysters | Charts and Charting | 1 | November 29th, 2003 04:52 AM |
x axis category name | Jen | Charts and Charting | 3 | October 21st, 2003 01:22 PM |