Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: [Solved] Charts : Creating a chart manually - adding data po

  1. #1
    Join Date
    3rd February 2004
    Posts
    25
    How can one add data points manually to create a chart? I can add the sheet and create the chart but I can't figure out how to create the array of data points and get them plotted.

    My data sets overlap so many points actually have multiple shapes and labels overlapping so many are illegible and difficult to work with. I'm considering just putting a single point wherever one should be and creating a single label listing all the data sets it applies to.

    thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310
    Hi Kotm14,

    To add points manually to your chart first select the chart and then from the Chart menu select Add Data.

    This will allow you add data as either a new series or new points.

    Cheers
    Andy

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    3rd February 2004
    Posts
    25
    Thanks,

    Sorry, I should have been more specific - I meant add points manually in a VBA subroutine.

    The data I want to graph is based on but not directly the data in my spreadsheet. My plan was to analyze the data, then create the array of points and the SeriesCollection in VBA. However, I can't figure out or find how to create the points or add them.

    Thanks again.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310
    Hi,

    This routine will add datapoints and a data series to an existing chart.

    Sub AddToChart()
    Dim rngNewPoints As Range
    Set rngNewPoints = Range("A1:A4")
    With ActiveChart
    ' new points
    With .SeriesCollection
    .Extend Source:=rngNewPoints
    End With
    ' new series
    .SeriesCollection.NewSeries
    .SeriesCollection(.SeriesCollection.Count).Values = rngNewPoints
    End With
    End Sub[/code]

    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. Replies: 2
    Last Post: September 4th, 2003, 01:07
  2. [Solved] Charts: creating charts using a macro
    By darian in forum EXCEL HELP
    Replies: 3
    Last Post: July 25th, 2003, 21:13
  3. Charts: Creating Charts from Lagre Data file
    By mroctobar in forum EXCEL HELP
    Replies: 4
    Last Post: June 7th, 2003, 04:21
  4. Charts: Help creating multiple charts from data
    By mroctobar in forum Excel and/or Access Help
    Replies: 5
    Last Post: June 7th, 2003, 01:44
  5. Replies: 2
    Last Post: June 4th, 2003, 20: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