none
xlValue not declared in VBA usingVb.net RRS feed

  • Question

  • With .Axes(xlValue)

    .MaximumScale = ActiveSheet.Range("$F$2").Value

     .MinimumScale = ActiveSheet.Range("$F$3").Value

     .MajorUnit = ActiveSheet.Range("$F$4").Value

     End With


    AK
    Wednesday, July 20, 2011 6:19 AM

All replies

  • Try XLAxisType.xlValue
    Wednesday, July 20, 2011 7:45 AM
  • thank s dear
    AK
    Wednesday, July 20, 2011 8:24 AM
  •            |

               |

               |

               |           Line chart

               -----------------------------------   x-axis

               1/1/2011,2/1/2011,............31/1/2011

               i want to show it as 1  2   3  4 .........31

    this is appear in x-axis

    please give me soln for it .


    AK
    Wednesday, July 20, 2011 8:27 AM
  • Hi Mujeeb85a,

    I am looking into this. I would recommend you to open a seperate thread for this problem to get more attention from the experts.

    Thanks

    Sorna

     

     

     

     

    Wednesday, July 20, 2011 11:57 AM