How to Fix Problem - Not your usual Excel 2007 Chart Axis Min/Max Question?

Not your usual Excel 2007 Chart Axis Min/Max Question


First, let me thank any and all for taking the time to possibly help.
Second, apologies in advance for not being very code-savvy.
 I suspect that the answer to my question lies in some VBA or macro coding.
 I hope not, but....
I want to extract the YMin/YMax values specified in an Excel Line Chart and have them populate cells.
And I need it for charts using BOTH Primary & Secondary Axes (4 data points in total)
(NOTE: Not the usual how-do-I-change-Min/Max-values-in-a-chart)
The data I want is displayed in the chart axis options window
The path I take is to right-click on the chart axis then on the FORMAT AXIS window I select AXIS OPTIONS.
The chart's YMax & YMin are automatically set.
I want those two data points and for each of the Y axes because I am using the Primary & Secondary axes.
What can I do if I don't know how to write or implement macros or VBA?
Thank you so much in advance


Keys to the Problem Not your usual Excel 2007 Chart Axis Min/Max Question




Press Alt+F11 to activate the Visual Basic Editor.
Select Insert > Module.
Copy the following code into the module:
Function ChartScale(ChartName As String, AxisType As String, MinMax As String)
    Dim cht As Chart
    Dim grp As XlAxisGroup
    Dim ax As Axis
    Set cht = ActiveSheet.ChartObjects(ChartName).Chart
    Select Case AxisType
        Case "Primary"
            grp = xlPrimary
        Case "Secondary"
            grp = xlSecondary
    End Select
    Set ax = cht.Axes(xlValue, grp)
    Select Case MinMax
        Case "Min"
            ChartScale = ax.MinimumScale
        Case "Max"
            ChartScale = ax.MaximumScale
    End Select
End Function
Switch back to Excel.
Use the function in cell formulas as indicated in the screenshot below:

Make sure that you save the workbook in a macro-enabled format (.xlsm, .xlsb or .xls, but not .xlsx).
You can download a workbook with the above example from
https://www.dropbox.com/s/ikhtt5sn9gze4xu/ChartScale.xlsm




Click here to download the registry repair application





Another Safe way to Repair the problem: Not your usual Excel 2007 Chart Axis Min/Max Question:



Click here to download the registry repair application .


How to Fix Not your usual Excel 2007 Chart Axis Min/Max Question with SmartPCFixer?





1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.



2. After the scan is done, you can see the errors and problems which need to be repaired.



3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed



Related: [Solved] Creating labels in Microsoft Word Starter,How to defrag my system? [Anwsered],Solution to Error: I can't find windows journal in my Windows 7 OS. It is included in the Starter edition?,Scripted Diagnostics Native Host not working,How to Resolve - system restore points keep vanishing in windows 7?,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22),Troubleshooting:pfstudiox Error,[Solved] Svchost Helper,[Solution] Sm1bg exe,How to Fix Problem - Io Device?,Fast Solution to Problem: I Can Error Code 0x6d9,Need to change the programs in Start Up mode.,needing to correct error- 0x80070002,New windows7 machine won't connect to my older vista network/workgroup,New Dell Inspiron 20 mouse will not work,New Windows 7 Asus laptop won't connect to internet

この記事へのコメント