Announcement

Collapse
No announcement yet.

VBA : excel chart

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • VBA : excel chart

    hi all..

    i like to ask if i have a table with many columns of values which will have functions inserted into the cells.

    Problem:

    How to create a line chart such that the chart compares Column C values with Column E values?

    Sorry i am really a newbie.. PLs help

  • #2
    Hi david2004,

    If you use the chart wizard you can do the following.
    Select the chart type XY scatter.
    Select the values from column C then whilst holding the CTRL key select the values from column E.

    Cheers
    Andy

    Cheers
    Andy

    Comment


    • #3
      hi andy

      Thx for helping..


      then if i want to do a polar plot.. as in to show the points around a circle such that i can show the difference between the calculated points from the actual circle at a particular radius.how can i plot the actual circle and the differentation?

      Comment


      • #4
        Excel charts do not include a built-in polar plot.

        If you have a set of data containing the angle and radius for each point then you can use some forumla to plot the points on an xy scatter chart.

        I just happen to have an addin to do this
        http://www.andypope.info/charts/polarplot.htm

        Cheers
        Andy

        Cheers
        Andy

        Comment


        • #5
          hi andy..

          you are really a professional. But i dont really understand how to write a code or formula for my case.

          on your link, i cant see the polar plotter page when i download the workbook.

          please help.
          eager to hear from you

          Comment


          • #6
            Hi david2004,

            Email me a copy of your workbook and I will take a look.

            Cheers
            Andy

            Cheers
            Andy

            Comment


            • #7
              hi andy

              have u received my email?

              david

              Comment


              • #8
                Hi David,

                Yes I have received your email.
                Will reply when sorted.

                Cheers
                Andy

                Cheers
                Andy

                Comment

                Working...
                X