Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    I am creating line charts from sets of monthly data (imported into Excel from Access reports) that do not have values for some months; e.g., the following set has no data for Apr and Jun.

    Jan 100
    Feb 300
    Mar 200
    May 150
    July 250
    Aug 300
    Sep 200
    [etc.]

    Is it possible to make the chart fill in zero values for months that have no data, so that every month has a marker on the chart, or is it necessary to insert rows for zero-value months manually?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could create a table with lookup formulas and use that as data source for the chart. See attached.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    Good idea - thanks.

Posting Permissions

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