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
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
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?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks