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
ADVERTISEMENT
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
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
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
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
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
View Related
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
Feb 20, 2008
I want to create grouped labels on a chart x-axis of the type created automatically when creating a pivot chart. For example: I have projects, samples and sample yields. There are multiple samples in a project so I have a sheet that looks something like this below:-
Project,Sample,Yield
2006ANG01,CTY001,1%
2006ANG01,CTY002,1.5%
2006ANG01,CTY003,1.2%
2007ANG03,CTY456,2%
2007ANG03,CTY457,1.9%
I would like to create a chart that has Project and Sample as the x-axis where the samples are all grouped into their project. Pivot charts do this nicely, but how to do it without a pivot chart? As you will see from the attached file I can get both Project and Sample on the x-axis, but the Projects are overlapping.
View 2 Replies
View Related
Mar 3, 2008
I have a chart that feeds from dynamic ranges which contain whole rows of null enteries displayed as #N/A. The charts do not plot these enteries (as it shouldn't) however it does display the category label even if it too is #N/A. Is it possible to remove the category label if all data for that row is null. ie the label is also removed from the chart.
View 2 Replies
View Related
May 15, 2014
I have a data set where a number of pieces of technology are listed in rows. For each piece of technology it can relate to a "Network" or a "Terminal" and the columns are yes/no as follows:
Tech Network? Terminal?
Tech 1 Yes No
Tech 2 Yes Yes
Tech 3 No No
Tech 4 No Yes
When I plot this on a pivot chart, I get the attached chart, where the x-axis relate to the hierarchies, i.e. Yes/Yes, Yes/No, No/Yes or No/No. As you can imagine, this is not very useful for the viewer as it's not clear what the yeses and nos refer to. It would be much better if I could rename the axis labels: "both"; "network only"; "terminal only"; or "neither".
Is this possible? And is there a solution that doesn't require me to change the source data? I'm happy to use a power pivot if that would make things easier.
View 1 Replies
View Related
Jun 9, 2006
Has anyone ever succeeded in offsetting category labels in a chart by surpressing the first category label. I am plotting monthly financial data over several years and want to show category labels for the month ends which coincide with quarterly month ends (i.e Mar-06, Jun-06, Sep-06, Dec-06). If I select 2 tick marks between categories I get Jan-06, Apr-06, Jul-06, Oct-6) because my first month and category label is Jan-06. Is there a way to offset displaying the first category label by two tick marks and start with Mar-06 and then go every two tick marks between category labels?
View 3 Replies
View Related
Sep 4, 2007
Is it possible to hide some of the number labels on an axis; e.g. in on the chart below to hide the X-axis label 96? Or only start numbering from 97 while the chart displays from 96. Auto Merged Post;Well I have a solution to hiding the first value on the excel X axis values labels just using a custom number format;
[Black][>96]General;
but is there anyway of formating more than a couple of the number labels individually?
View 2 Replies
View Related
Feb 7, 2014
I have an export from a database that I'm bringing into Excel 2010 of about 30K records. Data points are recorded numerically and I have their associated text "value label" (what it would be called in STATA, for example, not sure what it's called in Excel). I want to create various charts/pivot tables with the data and want the labels to be the text label, not the number.
For example, variable ASSIGNMENT has the following possibilities:
1
2
3
4
Here's what each of those "mean" (I have this in another table):
1 - Sick
2 - Overtime
3 - Court
4 - Present
How do I create a chart or pivot table where the labels are "sick", "overtime", etc., and not "1", "2", "3", "4"?
View 8 Replies
View Related
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
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
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
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
Nov 29, 2013
Right now I have this:
Screen Shot 2013-11-29 at 1.02.47 PM.jpg
How can I put another label under each bar (NOT outside end or inside end or any additional label. This is an actual label? For example, under the first blue bar labeled 56.7%, I also want to put N = 50 below the X-axis, above "Optimal." I also want to put N = 25 for the red bar immediately next to it labeled at 75.7%.
This is not a label, as it is below the X-axis.
An example of this can be found here (scroll down for second chart)
[URL]
View 1 Replies
View Related
Mar 18, 2013
I'm trying to plot a function with specific values marked on the X axis (or at least distributed according to the said values). Namely, I have something like this:
And while it does plot the Y's as I want them to be plotted, X'es are just used as labels, which causes 0 and 100 to be equally apart as 933,9 and 944. How can I plot it, then, so that I simply select my desired Y values, their corresponding X values and get the plotted function?
View 2 Replies
View Related
Jan 31, 2010
Hey guys, been searching around for a while now, yet to find an answer to this.
I have 3 columns of data ......
View 9 Replies
View Related
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
Jan 26, 2008
What is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies
View Related
Apr 2, 2013
I am putting together a graph and my manager wants the companies with a zero value in the bar chart to stand out (0 = really good). The only thing I could think of was making the individual x-axis label's font turn green if value was zero. Is there any way to accomplish this? (Additional: This chart will be updated every month with new data so I do not want to change by hand every month).
View 4 Replies
View Related
Apr 4, 2007
I have a set of data which I need to plot both unordered and ranked.
For the unordered (as is) data, a line graph is fine, as it gives the category labels along the x axis.
For the ordered data, i have a row with the ranking in, and then plot an xy scatter graph, so the values increase.
This obviously has the rank numbers along the x axis, not the corresponding category labels.
Is there anyway to force this? I know there are chart labelling add-ins on here, but our IT dept blocks the download.
The attched file is a very small example.
View 7 Replies
View Related
Jul 7, 2014
I have a dynamic column chart that may contain positive or negative (or both) values. The columns contain Data Labels positioned 'Outside End'.
I want to avoid the Data Labels (for the negative values) overlapping the x axis. Is there a way to do this via VBA?
I know how to update the chart axis via vba linked to cell values, but I can't figure out a formula I can use to calculate the minimum which takes into account the distance needed to avoid the overlapping problem.
View 1 Replies
View Related
Feb 5, 2014
I produced several charts in Excel 2007. They display just fine when using Excel 2007, but when we try to open it in our office computers (which uses Excel 2010), the Axis and Legend Labels simply vanish.I know there's these fixes for Excel 2007, deleting a buggy MS hotfix or installing the KB2597962 fix. But the problem is, I need it to display in our Excel 2010 computers.
View 6 Replies
View Related
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
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
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
Jan 28, 2013
I recently switched to Excel 2010 and have a rather peculiar problem.Every week I update a bunch of charts in different workbooks. By update, I pretty much mean just shifting the range over one column or down one row to incorporate newly added data.
So I right click the chart, select "Select Data", update all the Data series ranges and then I click on the Horizontal (Category) Axis Labels button "Edit" to update the Axis label range.
I do all that then press OK. The data series have updated, but the axis labels haven't. So then I do the procedure again for the Axis Labels, hit OK again and voila: It worked.
But I ALWAYS have to do this procedure twice. It will NEVER update the axis labels the first time around. Even though the little preview window below the edit button show the labels correctly.
View 1 Replies
View Related
