+ Reply to Thread
Results 1 to 2 of 2

Axis doesn't match source data

  1. 05-28-2018, 12:52 PM #1
    xxnsra
    xxnsra is offline
    Registered User
    Join Date
    05-28-2018
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    2

    Axis doesn't match source data

    Hi.

    I don't know why but i have a chart that the X Axis are not showing the data that i selected. Instead, he shows "1; 2; 3". Anyone knows why?

    UPDATE: I noticed that this problem occurs when i save the file with the chart in an ocult column

    capture1.PNG

    capture2.PNG
    Last edited by xxnsra; 05-28-2018 at 01:06 PM.
    Reply With QuoteRegister To Reply
  2. 05-28-2018, 02:17 PM #2
    xxnsra
    xxnsra is offline
    Registered User
    Join Date
    05-28-2018
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Axis doesn't match source data

    Solved only with macro

    Code:

    Set sht = ActiveSheet
    For Each co In sht.ChartObjects
    co.Activate
    For Each sc In ActiveChart.SeriesCollection
    sc.Select
    temp = sc.Formula
    sc.Formula = "=SERIES(,,1,1)"
    sc.Formula = temp
    Next sc
    Next co
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. WBs to 1 Sheet code doesn't allow to choose certain data range from source workbooks
    By Mahmoud.1st in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2016, 07:12 AM
  2. negative y axis on pivot chart but axis doesn't change
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:19 PM
  3. VBA pivot code doesn't work if the amount of source data becomes too large
    By punter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2014, 07:59 PM
  4. Don't know how to display data it in pivot table that doesn't exist in the org source but
    By Serdica in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-10-2013, 04:19 PM
  5. Excel Help Page Doesn't Match Excel (Date Category Axis Base Unit)
    By PMH in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-11-2012, 09:20 AM
  6. Y Axis Source Data
    By chalky in forum Excel General
    Replies: 0
    Last Post: 06-26-2006, 11:53 AM
  7. Formatting X Axis Source Data
    By Nate Carruthers in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1