Hello. From the example below, how can I make the numbers show up on the horizontal axis instead of the vertical one? Thanks.
Data
Jim Joe 100
Joey 200
Bob Tim 300
Tom 400
Hello. From the example below, how can I make the numbers show up on the horizontal axis instead of the vertical one? Thanks.
Data
Jim Joe 100
Joey 200
Bob Tim 300
Tom 400
assuming your numbers are in column B, use this, copied across...
=INDEX($B$1:$B$4,COLUMN(A1),1)
adjust references/ranges as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks