Need PivotChart x axis to cross Y axis at minimum Y axis value



  • 1. x axis of chart
    I am drawing a bar chart of age of firefighters. In the X axis I have the age interval and in the y axis I have numbe of firefighters with age in that range. The table is as follows: Age No 20 0 30 4 40 64 In this table, 20 means that those whose age are between 0 and 20 and 30 means ages between 20 and 30. Chart draws the bar exactly above these numbers, but for better interpretation I want the bar chart to appear between these number. I think this is a basic question and there is a solution for it. One solution is to put the age as follows: 0-20 20-30 30-40 in x axis but this is not a good solution. -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan
  • 2. Exporting Excel Graph to PowerPoint or Flash
    Dear Experts, I have a 16 sheet work book wich contains Data & assumptions. In one sheet I summarised all the results and assumptions into a Graph with Controls like Spin Buttons, Options buttons, etc. If I change values using the Spin buttons, correspondingle the graph will be changed. Now I want to export this graph along with the controls into my powerpoint presentation with or without teh whole excel file. When we normally paste the graph into Powerpoint slide, it can't be dynamic, i.e we can't change the values during the presenttaion in slide itself. Can anybody suggest any solution for this ?
  • 3. charts - 1 column and 2 lines
    Is it possible to make one chart with 1 series of columns and 2 series of lines. The colums are numbers, the lines are %. expl: - in columns: 3037 - 1663 - 987 - 338 - 1st line: 49%, 27%, 16%, 5% - 2nd line: 49%, 76%, 92%; 97% thanks, Katleen
  • 4. 3d line charts cause Excel 2007 to crash
    This is more of a bug report than a question (I've not been able to find a standard place to report bugs in Office 2007, the Connect site is for developer products such as Visual Studio etc). 3d line charts which work perfectly well on a pc with Excel 2003 cause Excel 2007 to hang when opened on my Vista pc with Excel 2007. I hope this is something which can be fixed when Service Pack 1 is released for Office 2007, as it is a very useful chart feature which we (and our clients) use a lot in one area of our work, and it may prevent our clients from migrating from Office 2003 to Office 2007.
  • 5. Help with this:
    In cell M4, put the label "Allowance." In cell M5, type "0.32" (the amount paid per mile). In cell M8, put a formula that multiplies the mileage in cell L8 by the mileage allowance in cell M5. (Remember to use an absolute reference to cell M5 and a relative reference to L8.) Copy the formula to cells M9:M11. In cell N8, sum the range C8:K8 and M8 (omitting column L, which is not an expense). Hint: One way is to use the SUM function for the contiguous range and add in the noncontiguous cell. Another way is to enter the range as two separate arguments of the SUM function.) Copy the formula to cells N9:N11. Select the column headings in row 6 and format them as bold.

Need PivotChart x axis to cross Y axis at minimum Y axis value

Postby QWFyb24 » Sat, 18 Aug 2007 10:01:23 GMT

I see an option to have x cross y at max y, but how can I say min y?

Re: Need PivotChart x axis to cross Y axis at minimum Y axis value

Postby Del Cotter » Sat, 18 Aug 2007 16:51:00 GMT

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 

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.

Similar Threads:

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,

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:

|            |


- 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

8. why can't Y-axis cross the X-axis at zero

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 44 guest