I see an option to have x cross y at max y, but how can I say min y?
I see an option to have x cross y at max y, but how can I say min y?
On Thu, 16 Aug 2007, in microsoft.public.excel.charting, Aaron < XXXX@XXXXX.COM > said: Jon Peltier taught me this one when I grumbled about the absence of a "min y" check box. As it turns out, setting the x crossing to some absurdly low figure like -999, far below the y axis minimum, does not make the x axis disappear, or ignore the figure and stay at the default zero. Instead it makes the x axis cross at, not below the y axis minimum, which is just what we wanted! It works, it's just not documented anywhere in the manuals or help files. Incidentally, setting the crossing to some absurdly *large* number also causes the x axis to be at the maximum, but defaults to "tick mark labels Low" whereas setting the x axis crossing to maximum via the check box defaults to "tick mark labels High". This appears to be the main function of the high x axis crossing check box. PS I suspect your axis will reset every time you refresh your PivotChart, which is just Microsoft not properly implementing stable table and chart formats for Pivot Tables/Charts. In theory you can even make panel charts in PivotCharts, but woe to he who presses "Refresh" after all that work! (does this show a need for a third party add-in that detects all the deviations from default format, and saves them to be re-applied after Refresh?) -- Del Cotter NB Personal replies to this post will send email to XXXX@XXXXX.COM , which goes to a spam folder-- please send your email to del3 instead.
1.Hiding Values Below Z Axis Minimum Value on Axis Charts
I want to use an area chart to show values for data series above a certain minimum Z axis value. Unfortunately, I can't find a way to hide parts of series that have values below this minimum. The chart shows a continuation of the series as though the values were AT the minimum. I've also tried to manually clear cells in the table that have values less than the mimum but that hasn't worked. Any suggestions?
2.Value (Y) axis crosses between categories and Secondary Value (Y) Axis
Hi all - I have 7 series on my chart Series 1 is column chart - may be area chart eventually (2007 data) Series 2 is column chart 2008 data Series 3 is column chart 2007 avg Series 4 is a column chart 2008 avg Series 5 is a line chart (32,0 benchmark) Series 6 is a line chart (points to column chart for 2007 avg, I then add text to right to explain the column) Series 7 is a line chart (points to column chart for 2008 avg, I then add text to right to explain the column) I would like the column charts for 2007 and 2008 data to be flush to the origin (12 data points each year) I would like the benchmark line chart of 32 to span the chart area from left to right (16 data points) >From what I've read, the way to accomplish this, is to clear the tick mark from Value (Y) axis crosses between categories when formatting the x axis. However, when I do that, the data point for 2007 closest to the origin appears cut-off on left side of column I more or less posted this information on Ozgrid a few days ago (Ozgrid is now down until Nov. 13 according to the site). Andy Pope replied that if I move the line charts to the Secondary Value (Y) Axis, that would resolve the problem. I must be doing something wrong. I did assign the line chart to Secondary Value (Y) Axis and then cleared the tick mark on the x axis: Value (Y) axis crosses between categories. However whatever datapoint is closest to the Primary Y Axis disappears entirely What am I doing wrong here? Send a confidential e-mail for a sample copy of the workbook Best regards, -markc
3.Should allow: "Value (X) axis crosses at *-MINIMUM-* value
4.Using a cell reference as the axis value for Horizontal axis crosses
Is there any way of referencing a cell as the value in the "axis value" area of the "Format Axis dialog box. I am currently entering a number i.e. 2.5. I would like to be able to have this number change when a user enterer a value in a cell? Would it have to be VBA code or is there another way?
5.Can't get the x-axis to cross at value 0 for both y-axes
Hello - I am working on an Excel chart with both a primary and secondary y-axis and only one x-axis. The primary has positive and negative values. The secondary has all positive values. I am using the secondary as a rank (by selecting the box to invert values so the highest rank has a value of 1 and appears at the top of the secondary y-axis, where rank 25 is the lowest possible rank and appears at the bottom of the secondary y-axis), in theory where the x and y axes meet. The x-axis is different points in time. So this chart shows trends over time. The issue I am having is the primary x-axis crosses the primary y-axis at 0 (y-axis value), which is what I want. However, the primary x-axis crosses the secondary y-axis at a value that is not the lowest value on the secondary y-axis. In this case, since I am using it as a rank, it is not crossing at the lowest rank. I am not showing the secondary x-axis associated with rank. I don't have this issue if all of the values on the primary y-axis are positive. In other words, the primary x-axis crosses at 0 on the primary y-axis and at the lowest rank on the secondary axis. My question is, is there a way to fix my problem? Is there an option where I can set the value where the primary x-axis crosses a value on the secondary y-axis? I know I can set the value for Primary x-axis to primary y-axis - and do the same for the secondary x and y axes, but I'm not aware of a way to cross this primary - secondary boundary. I imagine the graph's axes looking like a backwards 4 - the primary y-axis goes above and below the primary x-axis. The primary x-axis is approximately in the middle. The secondary y-axis is as high as the primary y-axis but only goes down to the x-axis (i.e., it does not extend below the x-axis). Is this possible? Something like this: | | |_______| | | Thanks! - Derek
6. X-axis to cross Y-axis at avrg Y-value
7. How to insert X axis scale values next to axis and X axis grid lin
Users browsing this forum: No registered users and 44 guest