Stacked Columns Chart - Use Non-numerical Data In The Vertical Axis?

Jun 10, 2014

I would like to create a chart with stacked columns. Usually, the data on the Y-axis is some kind of numerical data, such as budget. I would like to have the Y-axis have non-numerical data (= nominal categories).

Example :
Take the following data :
category | productname
red berry
red carrot
green cabbage
green apple

The ouput format i want is a chart which shows on the horizontal axis the categories red and green, and stacks in each category the right productnames on top of eachother; preferably each productname should have a different colour and showing data labels (e.g. "1", "green","apple" could be 1 specific data label).

I don't know how to achieve this, because if you display data as "count of productnames", then automatically you get something like a block with value 2, which doesn't show the different productnames inside that block.

Can the desired chart be made with Excel somehow?

View 6 Replies


ADVERTISEMENT

Create Chart With Names In Vertical Axis And Values In Horizontal Axis?

Mar 1, 2014

I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.

View 1 Replies View Related

Horizontal And Vertical Chart Axis As Value Axis

Jan 26, 2008

What is the best way to have both horizontal and vertical axis as value axis?

View 2 Replies View Related

Stacked Chart - 2 Labels On X-axis

Jan 10, 2012

Using the table, draw a stacked chart that has both the project name (A, B etc) and Month on the x-axis (below all the projects). the stacked chart should contain the count for cat1, cat2, cat3 and cat 4 for each project (in different but consistent numbers for each month).

I need this for a presentation today,

OctoberNovemberDecemberProject Cat. 1 Cat. 2Cat. 3Cat. 4Cat. 1 Cat. 2Cat. 3Cat. 4Cat. 1 Cat. 2Cat. 3Cat. 4A
00236111110001B
C
D
E
F
0012230182600425G
H
I
02114001602210J
K
L

View 2 Replies View Related

X Axis Chart Range Stacked Line To 100%

Aug 14, 2014

I am plotting a line chart wherein the X-axis is based on % and Y-axis is based on $. I have 5 scenarios wherein they have different ranges. I want to have the X-axis plotted up to 100%. How to get the X-axis stacked at 100%. See attached file.

View 1 Replies View Related

Stacked Column Chart With Multiple Axis

May 16, 2012

I am trying to chart this -

Code:

20112010
Net ($)Units Net ($)UnitsFFS** $ 808,227 61,370 $ 909,989 56,518 FFS
J-Code $ - 0 $ - 0 MCO*** $ 64,027 5,359 $ 26,691 1,614 MCO
J-Code $ - 0 $ - 0 SPAP/SCHIP $ 72,728 4,612 $ 110,592 6,490

Image can be viewed here - [URL] ...........

But I want units to appear on the secondary axis so its not so small.

View 3 Replies View Related

Secondary Axis Creates Stacked Bar Chart

Jul 11, 2007

When ever I add a secondary axis to my chart my bar chart sub type changes to a stacked bar chart. How do I keep the sub type bar chart? I have attached an example. I have tried playing with the gap and width of the bars but to no avail.

View 3 Replies View Related

Stacked Chart - Change Bar Colors Based On Date (X Axis)

Apr 19, 2014

I am wanting the colors of the bars in a stacked chart to change based on the date in the X Axis. As the current date arrives, the stacked bar needs to change to various blue shades. If the date is in the future, the stacked bar needs to be various grey shades.

View 2 Replies View Related

Excel 2007 :: Dates By Month On X-Axis In Horizontal Stacked Bar Chart?

Aug 24, 2012

I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.

In Excel 2007, I am trying to get the X-Axis to show major units of Months. However, in my chart options I can only change the Y-Axis to be Date/Monthly.

Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.

My data looks as follows:

System
Blocker
Production
Migrataion
Retired

Sys1
1/1/2012
780

Sys2
1/1/2012
400
60
90

Sys3
2/1/2013
30
5
1

The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.

My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.

What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.

20120823.xlsx

I can't seem to find the right combination of options to make that happen or force a scale on the X-Axis.

View 1 Replies View Related

Bar Graph With Values On Left Vertical Axis And Percentages On Right Vertical Axis

Jan 19, 2012

how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?

View 3 Replies View Related

Stacked Chart With Double Columns

Oct 30, 2006

According to my provided data, draw a stacked chart with double columns, each bar includes four types of data(Internet, PBS,Branches and Mail-in/Fax-in) and the x-axis are 1Q06, 2Q06 and 3Q06 repectively. It is urgent,pls provide the template for me. Many Many to all of you.

View 6 Replies View Related

Columns & Stacked Columns Chart

Dec 12, 2006

I am trying to get an Excel chart to include columns AND stacked columns in the same chart with no success. I have attached the Excel chart where I could only get stacked columns and I had to use a line chart for the secondary axis. I could not figure out how to get the secondary axis to be a set as a column just like the primary axis. I thought this could be done in Excel, I have searched the forums and tried to play around with the gap width and/or include a blank column but I still haven't been able to get this to work.

View 5 Replies View Related

Stacked Column With Average Line On Secondary Axis?

Apr 30, 2014

I have a stacked column chart that I need to show an average on, that is on a second axis and shown as a line rather than a column.

I have tried moving it to a secondary axis but then it keeps changing the graph to show only the average.

this is just one of about 25 graphs I am having to do like this.

stacked 2 axis.xlsx

View 2 Replies View Related

Excel 2010 :: Combining 100% Stacked Column With 100% Stacked Line Using 2 Groups Of Data?

Apr 24, 2014

I am trying to create a 100% stacked column which has a superimposed line chart over the top of it.

Basically % of yes and no for two separate datasets, but which share the same characteristics. The x-axis is months of the year.

CSP Yes
CSPNo
All Yes
All No

Apr-13
6
19

[code]....

I can create 2 separate charts. One for the yes/no of one set as a 100% stacked column. I then use 'no fill' on the No column to stop this from being seen.

I can create a 100% line chart for the second data type, and 'no fill' the 100% line that appears.

However, I can't merge the two charts to show the Yes % for one dataset as bars and the Yes % of the other as a line.

I am using Excel 2010 on XP.

View 2 Replies View Related

Overlay Line Chart On Top Of Stacked Column Chart?

Feb 15, 2012

I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.

View 9 Replies View Related

Draw Log Chart Or Edit Axis Intervals And Starting Axis Value

Apr 20, 2007

I have some numeric data that has to be put on a log chart. but there is no option for log charts. so i converted my data to log and then drew a chart but i am unable to edit the axis intervals and starting axis value. whenever i change the value it gets back to its default value,ie 1. can anyone tell me how to draw log chart or how to edit axis intervals and starting axis value?

View 6 Replies View Related

Chart X Axis Starts 1 Day Before Data

Nov 18, 2011

So I added a x-y scatter series to a line chart (in order to add a vertical line to the chart) and now I'm having a problem with the x-axis. It lets me select the start and end date, but when I put it on auto is starts 1 day before the data does. For example, if my data starts on 5/1/2011, the x-axis starts on 4/1/2011 and the there is no data point at that date.

I could manually change this, but the data is dynamic so the start date changes. Since I can do formulas in the format axis tab (date+1).

View 9 Replies View Related

Move Vertical Axis To Right Side?

May 16, 2012

is it possible on a line chart to move the vertical axis to the right side? or perhaps show it on both the left and right?

View 2 Replies View Related

Second Category Axis & Value Axis To Current Chart

Sep 27, 2006

how to incorporate another category and value axis to my existing chart.

1. I need to add a rank axis derived from my data column (C6-C15). This column should rank from highest to lowest and create a tie if any number is repeated. I have arranged the rank column in cells B38:L38 as they would appear. I would like this to appear on the top or bottom of the bar graphs.

2. Second I need to add the frequency of hits which = 3 derived from cell J1 This should appear on the chart were it is currently titled. This should create another bar graph colored green and labeled 3.

3. Lastly the numbers axis can remain the same as it appears on the chart or if it would be better to align as shown in cells B43:L43.

View 5 Replies View Related

Plotting With Words On Vertical And Horizontal Axis

Apr 29, 2014

I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?

View 1 Replies View Related

Chart Axis Has Numbers But Data Range Is Names?

Jan 21, 2014

I have created a chart but for some reason rather than the names appearing there are numbers. I did the chart successfully and then removed the data so that I could input another team's results and this happened.

View 3 Replies View Related

Any Way To Show Axis At Hourly Interval But Keep All Data In Chart?

Apr 13, 2012

I have got a lot of data to put in a chart that updates every 5 minutes with new data - i have a chart that Line chart that shows this.

It shows the cost of something every 5 minutes.

I have put this in a chart using offset but obviously i want to show the cost over the course of the day - because this updates every 5 minutes, the axis at the bottom (which has the time of the data) is massive and doesn't look good.

Is there a way to show the axis at an hourly interval but keep all the data in the chart?

View 5 Replies View Related

How To Show Vertical Axis On Both Right And Left Side Of Graph

Nov 22, 2011

Is there a way to show the Vertical axis on both right and left side of the graph or at least on the Right hand side?

View 5 Replies View Related

Add Vertical Line To 2 Graphs With Scale X Axis At Same Time

Sep 16, 2012

Two graphs with different scale x-axis.

Graph No. 1 with smaller time frame, Daily.
Graph No. 2 with larger time frame, Weekly.
Objective: Add vertical line to mark the same times in both graphs.

Trouble is both graph already utilise the secondary axis. VBA is allowed.

View 6 Replies View Related

How To Turn Bar Chart Into Stacked Chart

Feb 14, 2014

I have a two bar chart (red and blue) I'm trying to turn into a stacked chart. It has total cars and broken cars. There are a 100 total cars (10 broken). But when I stack them, it shows 110 total cars (it's adding instead of merging them). Once stacked, there should still be 100 total cars....but the tip of it should be red to show what amount is broken. It's adding the two together but it shouldn't....the number of broken cars is still part of the total.

View 1 Replies View Related

Stacked Bar Chart

May 22, 2006

I am trying to define a chart of TWO Stacked Bars. (it will be a little difficult for me, with my bad English, to explain – but I'm sure you will understand. My target is a chart as shown in the embedded picture. Take a look at sheet1:

This is a 75% completed chart. I managed to present the first 2 stacked bars. (light & dark green). Then I added a blank column ("D") and declared it as a "bar" on the 2nd. Y Axis. (This "D" series has now two values, of 5, which must be "Zeroed" when the chart is finished).

I managed to add the first part of the 2nd. Stacked bars. (Orange) I played a little with the Width and Overlap – and got the result shown in Sheet1. (When The "two fives" will change into 0 - the two orange bars will start from the X-Axis (Zero "Y" level)/ So far so good.

What I need now is to add the last Series (F2:F9) to be put ON TOP of the Orange Bar – but without success. If you'll take a look at Sheet2 you will see what I came up with. I DO NOT want them to be inside each other. I want them as in the embedded picture (side by side). In addition – I would love to present the Labels: Newspaper, Internet, Relevant, Non-Relv. Inside the chart (if possible)

View 2 Replies View Related

Two Stacked Bar Chart

Jul 13, 2006

I am trying to define a chart of TWO Stacked Bars. (it will be a little difficult for me, with my bad English, to explain – but I'm sure you will understand. My target is a chart as shown in the embedded picture. Take a look at sheet1:

This is a 75% completed chart.
I managed to present the first 2 stacked bars. (light & dark green).
Then I added a blank column ("D") and declared it as a "bar" on the 2nd. Y Axis.
(This "D" series has now two values, of 5, which must be "Zeroed" when the chart is finished).

I managed to add the first part of the 2nd. Stacked bars. (Orange)
I played a little with the Width and Overlap – and got the result shown in Sheet1.
(When The "two fives" will change into 0 - the two orange bars will start from the X-Axis (Zero "Y" level)/ So far so good.

What I need now is to add the last Series (F2:F9) to be put ON TOP of the Orange Bar – but without success. If you'll take a look at Sheet2 you will see what I came up with. I DO NOT want them to be inside each other. I want them as in the embedded picture (side by side). In addition – I would love to present the Labels:
Newspaper, Internet, Relevant, Non-Relv. Inside the chart (if possible)

View 2 Replies View Related

Stacked Area Chart In VBA

Oct 28, 2013

Code:
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlAreaStacked

I created a simple stacked area type in vba. Is it possible and how to have this stacked area to get values from combobox and textbox?

View 3 Replies View Related

Dynamic Stacked Bar Chart

Apr 28, 2006

I am trying to develop a dynamic stacked bar chart, I have a consistent number of columns defining the x axis and a variable number of rows defining the y axis (the stacked data). Is it possible to generate a dynamic stacked chart. I have tried using dynamic named ranges but I can't get it to work for a stacked chart.

View 7 Replies View Related

Stacked Bar/Column Chart

Oct 22, 2006

i have a chart made but it will only read numbers what i looking for it to do is read cells filled. beacuse none of the cells will have numbers in them. example column I,J,K,L will have a letters in them. starting on row 2 on down till the end. what i'm looking for is if I2 has a letter in it it will read as one for the chart. and will ignore the other columns if K7 has a letter it will read as one and ignore the rest of the columns. this will go on till the end of the sheet. and all rows with nothing in them will be ignored. is this posable?

i think it is bacisly giving a value to a letter and having the chart inturpat that value as 1 and then adding them up. if posable i just thought of maybe the letter could be turned into a date to give an ongoing graph for the info. maybe thats the wisest thing to do to show what each day looks like. hmm i have to play around with it. just typing this out i think i figured a way to do it.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved