+ Reply to Thread
Results 1 to 2 of 2

Dynamic Chart X Axis Problems

  1. #1
    Registered User
    Join Date
    03-16-2016
    Location
    indiana, US
    MS-Off Ver
    2016
    Posts
    33

    Dynamic Chart X Axis Problems

    Hello guys,
    I have a workbook with some dynamic named ranges as inputs to a chart. The y-axis values work great however the x-axis values show up from 0 to 100. The dynamic named range equations is as follows:
    =OFFSET('Worksheet Name'!$B$600,0,0,COUNTA('Worksheet Name'!$B$600:$B$1000),1)
    It can be up to 400 data points long, but the current data is 100 data points. If I lengthen or shorten the data set it changes the x-axis to the number of points. So for some reason the chart is looking at the number of points and not the actual values of the data.
    Here is the chart data set setup:
    x-axis:
    ='WorkbookName.xlsm'!XDynRange
    y-axis:
    ='WorkbookName.xlsm'!YDynRange

    Thanks in advance for any help!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,081

    Re: Dynamic Chart X Axis Problems

    Really hard to say without seeing and example file.
    What you describe should work.

    Is the chart type as scatter chart? If so ensure all the x data values are numeric, otherwise excel will default the x values to a simple numeric sequence.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Chart on both X and Y axis with VBA.
    By Pinkoto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2017, 05:08 PM
  2. Dynamic Axis in chart
    By musicbox1970 in forum Excel General
    Replies: 3
    Last Post: 03-03-2017, 07:02 AM
  3. Problems creating a template chart with an adjustable x-axis range.
    By SmallTownGriff in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-10-2013, 05:49 AM
  4. Legend Only Shows Used Axis on Dynamic Chart (X, Y and Y2 axis)
    By TEBrown in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-21-2012, 10:15 AM
  5. Chart from Pivot table - Axis problems
    By neil40 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-30-2012, 10:16 AM
  6. [SOLVED] y axis problems in chart
    By gbl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-12-2006, 03:10 PM
  7. Problems with X Axis for a Line Chart
    By Shadowman13 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-18-2005, 10:06 AM

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