Results 1 to 5 of 5

Charts - x-axis data=A column; y-axis data=B column

This is a discussion on Charts - x-axis data=A column; y-axis data=B column within the Excel Questions forums, part of the Question Forums category; In my worksheet I have 2 columns of data. 600 data points in each column. 1. How do I set ...

  1. #1
    New Member
    Join Date
    Dec 2002
    Posts
    1

    Default

    In my worksheet I have 2 columns of data. 600 data points in each column.

    1. How do I set a line graph/chart up so that column A-cell 1 ($A$1) is the x-axis point and then the point plotted on the graph is column B-cell 1 ($B$1) and so on for all the cell entries in the 2 columns?

    2. Once I have the above graph completed how do I import new data into those same cells and have the graph update to display the new data points?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    See the Excel Help topic for "Create a chart".

  3. #3
    New Member
    Join Date
    Aug 2007
    Posts
    2

    Default

    I know this is an OLD post, but if you can't be more helpful than that, Mark W., then don't reply.

    I believe I have found the answer to this question. The answer is, at least if you want a line chart, that it cannot be done. If anybody has any information to the contrary, then please enlighten me.

  4. #4
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,563

    Default

    If you are referring to Q2 Then select your new data and copy, select the chart, Edit > Paste Special and follow the prompts to add the new data.
    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    New Member
    Join Date
    Aug 2007
    Posts
    2

    Default

    Thanks for your reply. I can't test it until Monday, but even then, I need to do it programmatically - via VBA. Got any pointers on how to do that? With a Line Chart?

    Thanks again!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com