Results 1 to 4 of 4

Dynamic X-Axis in excel chart using form control

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    South Carolina, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Dynamic X-Axis in excel chart using form control

    I am able to build a spreadsheet with a graph that changes the series for the Y-Axis by utilizing form control. That way with a click of the button in the chart I can change the data displayed in the chart.

    Is it possible to do this for the X-Axis? To be able to quickly change the time frame? By using form control? I have tried building a text string that changes dynamically but I cannot seem to get the "Select Data" box to accept the text string.

    Sorry if that is unclear.
    Last edited by ejdrouil; 07-15-2013 at 04:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic x-axis chart
    By NeoFlex in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-02-2013, 09:50 AM
  2. [SOLVED] Dynamic control chart
    By aka1 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 08-08-2012, 02:45 PM
  3. 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
  4. Replies: 3
    Last Post: 04-25-2012, 04:18 AM
  5. chart with dynamic x axis
    By name in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-04-2006, 10:45 AM

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