Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

[Solved] Charts : Probability Scale

I am trying to create a Log/Probability Chart in Excel 97.
I have a column of Flow values and a corresponding column of Exceedance % values.
Using old, faded graph paper with a Log Scale (y-axis) and a Probability Scale (x-axis) the resulting plot is linear.

Using the "Format Axis..." dialog box, I can get Excel to give me a Log Scale on either axis, but a Probability Scale does not seem to be an option.
Any suggestions?

Thanks


Post your answer or comment

comments powered by Disqus
Hello I need some help please,

I would like to know how to get a probability scale in X axe (in a graph)

the probaility scale looks like this:

____________________________________________________
1 1.05 1.25 2 5 10 20 50 100 200 500

there is a logarithmic scale option but is different and looks like this:

_______________________________________________
1 10 100 1000 10000

thank youuuuuu

Hello everybody,

I wonder if somebody knows how to set the X axe to a probability scale. This is for a graph is excel and It would look something like this:

_____________________________________________________
1 1.05 1.25 2 5 10 20 50 100 200 500

thank you for the help

Is it possible to print an Excel chart to scale. For example if with
VBA code I set the Plotarea.InsideWidth to 288 and the
PlotArea.InsideHeight to 144 should it print out as 4" x 2"

Seisman.

How to draw chart: log scale on X axis, natural scale on y axis? sample data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3

Is it possible to print an Excel chart to scale. For example if with
VBA code I set the Plotarea.InsideWidth to 288 and the
PlotArea.InsideHeight to 144 should it print out as 4" x 2"

Seisman.

I am trying to change the code from Jon Peltier's website for "Link Chart Axis Scale Parameters to Values in Cells" from a worksheet change event to a macro/button controlled code. I however have not found the solution.
Can anyone help me ?

http://peltiertech.com/Excel/Charts/...nkToSheet.html

Thanks,

Ronald de Vries

Hi.

If I have 3 charts on a worksheet......how could I work out what the maximum value of any of the charts is and then scale all 3 charts to to be on the same scale ?

Thanks for any help

Steve

Is there a way I can have my chart data auto-scaled? I appreciate your time and efforts

Goin' Nuts! I keep getting the same error no matter what I do to try to change Min and Max scale on my chart using VBA OR a macro that I recorded doing just that! I get:

Run-time error ‘1004’
Unable to set the MinimumScale property of the Axis class.

VBA stops at the "MinimumScale =" line on either set of code . Below I'll put the code I wrote, and THEN an actual macro I recorded MAKING A CHANGE, which then won't work when I run it. Both sets of code give the same error.

Note: I CAN change these "manually"--the charts aren't somehow "locked" or something (they're "raw" freshly created charts--I've done no unusual "fiddling" with them). Also, I can assure you that the MaxScale and MinScale numbers are reasonable (as examined in "break" VBA)...but, again, even a recorded macro of a successful manual change of the values will not work!

Code:
Dim BarInterval As String, MinScale As Double, MaxScale As Double
BarInterval = Cells(47, 2)

If BarInterval = "2 min" Then
    MinScale = Evaluate("TwoMinRngMin") - 0.001
    MaxScale = Evaluate("TwoMinRngMax") + 0.001
    With Sheet1.ChartObjects("Chart 4").Chart.Axes(xlValue)
        .MinimumScale = MinScale
        .MaximumScale = MaxScale
        .MajorUnit = 0.0005
    End With
    With Sheet1.ChartObjects("Chart 7").Chart.Axes(xlValue)
        .MinimumScale = MinScale
        .MaximumScale = MaxScale
    End With
End If
Recorded Macro

Code:
ActiveSheet.ChartObjects("Chart 4").Activate
    ActiveChart.Axes(xlValue).MajorGridlines.Select
    With ActiveChart.Axes(xlValue)
        .MinimumScale = 1.5575
        .MaximumScale = 1.565
        .MinorUnitIsAuto = True
        .MajorUnit = 0.0006
        .Crosses = xlAutomatic
        .ReversePlotOrder = False
        .ScaleType = xlLinear
        .DisplayUnit = xlNone
    End With


Hi,

I have a workbook with about 60 tabs - 1 data tab, and the 59 others are graphs. Is there a way to set the y-axis scale on each one without setting the scale on each one individually? (i.e. set a workbook scale for charts of 50-200)

Thanks

I have an application that generates the chart automatically. It works with millions and thousands of dollars as the values but each the dollar amounts vary each time.
I am getting an error where the scale on the y axis reads 2 2 1 1 0 0 instead of the correct way.

I am working on a report in Excel where we compare four models with eachother.
Therefore we use four charts which we place next to eachother. The data is
filled into the datasheet automatically from access through macro's.

The problem is that the scale of the x-axis differs on each chart while we
want the same scale on all four charts. Auto-scaling scales each chart
individually, so that is not an option as well.

The only solution what I can come up with is making a macro that searches
for the largest value in the datasheet and then setting the maximum of each
axis to that value.
This seems quite a lot of work, so my question is, is there any other way to
do this?
Thanks.

Hello all. I have this problem, I will need to create this chart that I don't
know how to.

Serie 1 is below which needs to be time scaled
Date Count
1/1/2006 12
1/2/2006 3
1/3/2006 5
2/1/2006 18
2/3/2006 4
2/18/2006 9
4/1/2006 18
7/4/2006 38

Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with
symbols.

1/31/2006
2/18/2006
4/2/2006

I will look something like you have a line of count on a time-scaled chart,
with 3 dates point in the x-axis. Please give me some advice on how to do
it. Thank you all.

I have a chart on a worksheet and want to make the Y scale maximum value
equal the value of cell Y3 (this is a merged cell range Y3:Y5), rounded up to
the next “5” increment. For example, 101% in merged cell Y5 would be 105% in
the chart Y scale maximum. How would I do this?

I am trying to build a dashboard in excel 2007 beta, but when I format the
content to fit to one page, the charts don't scale down when I print even
though they fit in the required cells in design mode! Is this a bug? Has
anyone else had this problem?

Hi All,

I have several charts the scales of which I want to adjust based on the maximum and minimum vale of a set of named ranges.

So for eg: Named ranges are NAMR1, NAMR2, NAMR3 etc and the chart names are CHRTAB, CHRTDE, CHRTFK, CHRTCG etc. Now say the MAX(NAMR1, NAMR2, NAMR3) = 34 and MIN(NAMR1, NAMR2, NAMR3) = -14. Now for all the four charts their scales should adjust based on this max and min value so max as 34 and min as -14.

Any ideas how this can be achieved using VBA?

Thanks

How would I change a chart's scale with VBA? Right now I have the following:

   
ActiveSheet.ChartObjects("Chart 7").Activate
    ActiveChart.Axes(xlValue).MinimumScale = price_chart_min
    ActiveChart.Axes(xlValue).MaximumScale = price_chart_max
and would like to do this without excel physically selecting the chart (first line of code, but have it simply change the value of max and min.

Thank you.

I created two charts in the second the difference between max and min is greater.
The scale is automatic, but works only in the first

why?

see attach file

Can anyone recommend a procedure for creating large format scaled charts?

Ideally, I'd like the y-axis to have a scale of 5 inches per unit and an
x-axis of 1 inch per 500 units.

Ive used the following macro to set the plot area, but i'd like to automate
it a bit based on data ranges.

Sub ResizePlotArea()
'
' Resize Plot Area Macro
' Macro recorded 6/8/2006 by steve'

'
'Selection.Width =(desired width*72) +36 (36 dependant on axis font)
'Selection.Height =(desired height*72)+25 (25 dependant on axis font)

ActiveChart.PlotArea.Select
Selection.Left = 20
Selection.Top = 108
Selection.Width = 360
Selection.Height = 720
End Sub

Thanks.

Hi,

I want to create a 2 axis chart. The 2 y axes have a relationship two each
other. Thus if I change the scale on one, I want the other to change to
keep the correct relationship. Can this be done?

When using logarithmic scaling for charts the scaling interval is given in
powers of 10 (1, 10, 100, 1000 etc). I want to be able to change the scaling
interval to show data at a smaller log. interval (e.g. between 100 and 200).
This is not at present possible in Excel but it would be extremely useful.

I have a series of charts displayed on a UserForm, however they are too small. If I scale the charts in the worksheet by selecting the chart, going to the format ribbon and selecting 'Scale' from the 'Size and Properties' dialogue, even though my charts will scale on the worksheet, when viewed on the UserForm, they appear at the size they were before I scaled them and when I close the UserForm, the charts themselves also revert back to their pre-scaled size?

Is there anyway to actually permanently scale charts in 2007/2010.

I also am trying to figure out the correlation between the size units VBA uses and Excel uses. I had read that VBA uses TWIPS but when converting TWIPS to CM this doesn't seem to tally. I want to scale my charts to fit the ImageControl size I have set up on my UserForm - is there an easy, obvious way to do this?

I am trying to create different charts using pivot chart option. For different catagories, the scale of the chart automatically changing. I want to fix the scale, so that I would be able to compare one category chart with other. Let me know how to fix the scale for pivot charts

I am working on a report in Excel where we compare four models with eachother.
Therefore we use four charts which we place next to eachother. The data is
filled into the datasheet automatically from access through macro's.

The problem is that the scale of the x-axis differs on each chart while we
want the same scale on all four charts. Auto-scaling scales each chart
individually, so that is not an option as well.

The only solution what I can come up with is making a macro that searches
for the largest value in the datasheet and then setting the maximum of each
axis to that value.
This seems quite a lot of work, so my question is, is there any other way to
do this?
Thanks.


No luck finding an answer? You could always try Google.