none
Chart Axis title RRS feed

  • General discussion

  • I was try to write a code that would plot a graph and also label the axes. But it appear that one axis label appears and the other disappear.

    Can somebody help with a code that would show both axis label.

    Please find attached me codes and the plot I was trying to make

    '    ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = PyName
        ActiveSheet.ChartObjects(sh_name).Activate
        ActiveChart.ChartArea.Select
        ActiveChart.SetElement (msoElementPrimaryValueAxisTitleRotated)
        ActiveSheet.ChartObjects(sh_name).Activate
        ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = PyName
        
        ActiveSheet.ChartObjects(sh_name).Activate
        ActiveChart.ChartArea.Select
        ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
        ActiveSheet.ChartObjects(sh_name).Activate
        ActiveChart.Axes(xlValue).AxisTitle = xName ') xlPrimary)

    Thursday, December 8, 2011 8:06 AM

All replies