Announcement

Collapse
No announcement yet.

Visual Basic help

Collapse
X
Collapse
 
  • Page of 2
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 template Next
  • #1

    Visual Basic help

    How do I have more than two series in an MSChart? And in VB for Applications (for Excel), how do I modify the contents of a Chart (to the extent of adding/redimensioning series, and to change series colors and such)?

    The only VB book I have is no help, and the only VB for Apps book I have is a useless reference
    Tags: None
  • #2
    Try look here - it's a nasty place but sometimes I have succeded to find what i looked for :

    http://search.microsoft.com/search/results.aspx?View=en-us&p=1&c=4&st=b&qu=MSChart&swc=4&na=33&cm=512
    With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

    Steven Weinberg

    Comment

    • #3
      Application.Charts will give you Chart objects that are chart sheets.
      Worksheet.ChartObjects will give you ChartObject objects that are charts in a worksheet. After that, you can modify it by changing the object's properties, there were Axes, ChartTitle and loads of others I don't immediately remember.
      Solver, WePlayCiv Co-Administrator
      Contact: solver-at-weplayciv-dot-com
      I can kill you whenever I please... but not today. - The Cigarette Smoking Man

      Comment

      • #4
        The problem is, when I tried to modify ChartTitle, it told me I couldn't (forget the exact error).

        Comment

        • #5
          What do the code look like ?
          With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

          Steven Weinberg

          Comment

          • #6
            Gee Kuci, you should know that to get the best feedback on programming problems, you post the code and the error .
            Solver, WePlayCiv Co-Administrator
            Contact: solver-at-weplayciv-dot-com
            I can kill you whenever I please... but not today. - The Cigarette Smoking Man

            Comment

            • #7


              Yeah, it's resembles a little Molly Bloom's picture guessing threads.
              With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

              Steven Weinberg

              Comment

              • #8
                I can't post the code, it's for something at work and is "sensitive-unclassified" which means I can't take it off-base.

                Comment

                • #9
                  You don't have to post the whole goddamn program - just the offending line and maybe a pair or two around it.

                  With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

                  Steven Weinberg

                  Comment

                  • #10
                    Plus the computer it's on doesn't have internet access.

                    Comment

                    • #11
                      Originally posted by Kuciwalker
                      Plus the computer it's on doesn't have internet access.
                      I guess that the offending line is shorter than what you just wrote
                      With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

                      Steven Weinberg

                      Comment

                      • #12
                        Dude, I'm not even at work now.

                        It's something like Chart1.ChartTitle = "stuff" and it's spits out an error.

                        Comment

                        • #13
                          Well, that didn't hurt much

                          The reason you get an error could be this :

                          http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbagr10/html/grobjChartTitle.asp


                          You miss the .text part
                          With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

                          Steven Weinberg

                          Comment

                          • #14
                            Ah.

                            Comment

                            • #15
                              Originally posted by Kuciwalker
                              Plus the computer it's on doesn't have internet access.
                              Strange - at my company people would have serious trouble doing their jobs if they hadn't IA.

                              Are they worried you would start downloading too much art ?
                              With or without religion, you would have good people doing good things and evil people doing evil things. But for good people to do evil things, that takes religion.

                              Steven Weinberg

                              Comment

                              Previous 1 2 template Next
                              Working...
                              X