+ Reply to Thread
Results 1 to 2 of 2

Dates in Chart Axis

  1. #1
    Candyman
    Guest

    Dates in Chart Axis

    I am trying to create 10 charts auomatically from sequential pages. The data
    is simple; dates in Column A, titles accross the top, and values in the body.
    6 lines of data. I ran the wizard and picked up most of the coding. However,
    when the code runs it does not give the dates consistently at the bottom of
    the charts. Do I assign the xValue or am I barking up the wrong tree? I
    can't figure out the code format or I must be somethiong withthe xvalue
    statemnet. I eventually want to assign the colors and line size based on the
    category, but i can't get past first base!

    If any one has an example of this process and possibly assigning colors I'd
    REALLY appreciate it!

    Thanks





  2. #2
    Jon Peltier
    Guest

    Re: Dates in Chart Axis

    How is it inconsistent? Use SetSourceData to define the range of data that includes
    the dates and headers.

    Excel will likely provide a time-scale axis if it recognizes the data as dates. This
    means it will make a proportionally spaced axis, instead of an axis with a tick at
    each date. If you want a tick mark for each date, with equally spaced ticks
    regardless of the duration between ticks, go to Chart Options on the Chart menu, and
    on the Axes tab, choose the Category option for the Category (X) Axis.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Candyman wrote:
    > I am trying to create 10 charts auomatically from sequential pages. The data
    > is simple; dates in Column A, titles accross the top, and values in the body.
    > 6 lines of data. I ran the wizard and picked up most of the coding. However,
    > when the code runs it does not give the dates consistently at the bottom of
    > the charts. Do I assign the xValue or am I barking up the wrong tree? I
    > can't figure out the code format or I must be somethiong withthe xvalue
    > statemnet. I eventually want to assign the colors and line size based on the
    > category, but i can't get past first base!
    >
    > If any one has an example of this process and possibly assigning colors I'd
    > REALLY appreciate it!
    >
    > Thanks
    >
    >
    >
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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