Results 1 to 6 of 6

Dynamic Chart Vertically

Threaded View

  1. 10-31-2013, 10:22 AM #1
    Steph12
    Steph12 is offline
    Registered User
    Join Date
    10-31-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    3

    Dynamic Chart Vertically

    Hi Guys,

    I have a chart that has data that goes horizontally I want to make this dynamic however I have created a formula that doesn't work when I try and put it into my chart.

    =OFFSET(Toys!$B$19,0,COUNTA(Toys!$B$19:$CA$19),0,0)

    Is it that I'm using counta?

    where am I going wrong please help :/

    Thanks

    Steph
    Last edited by Steph12; 10-31-2013 at 10:24 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Vlookup on Dynamic Range that expands vertically and horizontally
    By huy_le in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2013, 03:47 PM
  2. List of numbers vertically which I need vertically next to each other separated by a '|'
    By david1987 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2012, 12:37 PM
  3. Vertically align text in chart
    By EricN87 in forum Excel General
    Replies: 6
    Last Post: 02-27-2012, 10:39 PM
  4. Flip the chart vertically
    By tkuia in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-15-2007, 02:28 AM
  5. How to create a floating bar chart vertically not horizontally...
    By Cristina in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-30-2006, 04:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1