Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: VBA : excel chart

  1. #1
    Join Date
    5th January 2004
    Location
    singapore
    Posts
    43
    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    5th January 2004
    Location
    singapore
    Posts
    43
    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?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    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

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    5th January 2004
    Location
    singapore
    Posts
    43
    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

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    Hi david2004,

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

    Cheers
    Andy

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    5th January 2004
    Location
    singapore
    Posts
    43
    hi andy

    have u received my email?

    david

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    Hi David,

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

    Cheers
    Andy

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Excel Pie Chart Bug???
    By Laplacian in forum EXCEL HELP
    Replies: 3
    Last Post: March 6th, 2005, 06:16
  2. Using Excel Chart Event Procedures with a chart embedded in PowerPoint
    By hitoshi in forum Excel and/or Powerpoint Help
    Replies: 1
    Last Post: August 3rd, 2004, 02:13
  3. Excel Chart
    By SmilnLisaMarie in forum EXCEL HELP
    Replies: 4
    Last Post: May 22nd, 2003, 05:13
  4. Saving Excel Chart
    By arleney in forum EXCEL HELP
    Replies: 1
    Last Post: March 5th, 2003, 21:20

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno