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

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

- Probability SCALE in X axe..please
- Probability Scale in X axe (for a graph)
- Printing charts to scale
- How to draw chart: log scale on X axis, natural scale on y axis?
- Printing charts to scale
- Link Chart Axis Scale Parameters to Values in Cells via Macro or Button
- Chart axis scales
- Chart Auto-Scaling
- Changing chart Axes scales: Neither VBA or rec macro work!
- Chart/Graph Scale Changes
- Excel Chart Axis Scale Problem
- Grouping axis scale multiple charts
- How chart time scale x-axis with another date serie
- Cell value as chart scale maximum
- How do I get charts to scale down with remainder of cells in 2007
- Adjusting charts scale using max-min value of named ranges
- Changing chart scale with VBA
- Excel chart automatic scale
- Charts with scaled axis
- 2 Axis chart and scaling
- Logarithm scaling for charts
- Scaling Charts in Excel 2007
- Pivot Chart Fixed Scale - help
- Grouping axis scale multiple charts

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

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

VBA code I set the Plotarea.InsideWidth to 288 and the

PlotArea.InsideHeight to 144 should it print out as 4" x 2"

Seisman.

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

VBA code I set the Plotarea.InsideWidth to 288 and the

PlotArea.InsideHeight to 144 should it print out as 4" x 2"

Seisman.

Can anyone help me ?

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

Thanks,

Ronald de Vries

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

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 IfRecorded 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

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 am getting an error where the scale on the y axis reads 2 2 1 1 0 0 instead of the correct way.

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.

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.

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?

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?

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

ActiveSheet.ChartObjects("Chart 7").Activate ActiveChart.Axes(xlValue).MinimumScale = price_chart_min ActiveChart.Axes(xlValue).MaximumScale = price_chart_maxand 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.

The scale is automatic, but works only in the first

why?

see attach file

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.

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?

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.

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?

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.