Results 1 to 9 of 9

Graphing dynamic range with vba

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    14

    Graphing dynamic range with vba

    Hi!
    I am trying to graph a dynamic range using VBA, but don't know how to get all of the data I need on to one chart.
    I came very close, please see the attached sheet. I've gotten thus far thanks to John Peltier's blog.

    The data on the sheet looks like this:
    .......................Apr2 Apr 14 Apr 21
    Physical percentage 90 92 93
    Economic percentage 91 93 94

    I can get the numbers onto the graph, but I cant get the dates to be displayed on the x-axis of the graph through VBA.
    If I take the boxes around the data and drag them over the dates, they appear on the graph.

    What can I do to make the dates appear on the x-axis of the chart?
    Its almost done. Thank you for the help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1