+ Reply to Thread
Results 1 to 2 of 2

Help on chart creation

  1. #1
    Registered User
    Join Date
    05-22-2017
    Location
    Austin
    MS-Off Ver
    Office 2010
    Posts
    1

    Help on chart creation

    I am attempting to build a 2-D Column Chart that summarizes the data attached. The view requires 2 x-axis of which one of the values is text. Any help on this is appreciated

    Capture.JPG
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,578

    Re: Help on chart creation

    It is not clear to me exactly what you want or what you are having trouble with.

    Can we assume you are familiar with the basic steps of creating a chart?

    Here's what I would suggest trying:
    1) Switch row 2 and row 3 so "type" is on top and "year" is on the second row.
    2) Clear B2 and B3 (not necessary, but makes it more likely that Excel will correctly identify that category x axis data. Once the chart is created, you can put the values back).
    3) Clear the second "Revenue" (D2), Expenses (F2), and EBITDA (H2)
    4) Select B2:H8
    5) Insert -> Chart -> Column Chart -> Clustered column
    6) Format chart as desired.

    Is that close to what you want? What do you have trouble with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Convert Chart Creation Macro to Stacked Column Chart
    By JBeaucaire in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2014, 01:08 PM
  2. Bar chart creation
    By illinge in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-14-2009, 11:50 AM
  3. Chart creation in VBA
    By Lewis1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2009, 05:39 AM
  4. Chart Creation
    By Hoopsah in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-21-2007, 08:02 AM
  5. [SOLVED] Problem with chart creation.
    By daniel chen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-11-2006, 12:10 AM
  6. Problem with chart creation
    By daniel chen in forum Excel General
    Replies: 2
    Last Post: 01-08-2006, 02:30 PM
  7. Bar of Pie chart - Need Bar creation
    By Craigm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 08:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1