Clustered And Stacked Charts Including Line Graphs
Mar 15, 2012I need to show a chart with new and return visits 2 years side by side. I also need to show a budget line and 2 seperate utilization lines. How to show this.
View 1 RepliesI need to show a chart with new and return visits 2 years side by side. I also need to show a budget line and 2 seperate utilization lines. How to show this.
View 1 RepliesI have two sets of data (delivery destinaition & profit) for 2 separate depots (A&B) delivering to 3 countrys (1,2,& 3). I have used a clustered column chart to show the number of deliveries to the different countries by each depot. The problem I have is that I want to add separate lines (one for each depot) showing the profit figures for each destination (on a secondary axis).
View 4 Replies View RelatedI 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.
I would like to be able to add a line (a trend line) to a clustered column chart. The attached jpg (picture copied from Excel Charts - Easy Excel Tutorial) shows the general structure, with the red (poorly) hand drawn lines representing what I want to add to the chart.
If using Excel's Trend line functionality is not an option, I have already calculated the trend points adequately, so have the data to add as an additional series or combine with an existing series. (using Excel 2010)
I'd like to create a stacked column chart that compares monthly results from the sales staff but can't get excel to show what I need.
Each salesman has a total monthly sales figure which includes an element of profit and I'd like to see the splits in a stacked column chart. E.g in May, Simon's total was £7295 of which £863 was profit.
MayMayJuneJune
TotalGPTotalGP
Simon7295863121231912
Mike32397480995670199644
Gordon39567472631393362539
The chart should have a column for each salesman and show both the total figure and the profit for each month in the same column so with May and June figures there should be 6 columns on the chart.
How do I lay the data out in excel to get the right graph?
I'd like to put a spinner button on a chart that will change the x-axis date range. The data is in day/month/year format, but ideally I'd like to have the spinner button move in 1 year increments. The most recent date should always be present and changes should just impact how far back in history to go. I have basically no experience with vba coding, so please be as thorough and simple with your responses/solutions.
View 2 Replies View RelatedI want to prepare a graph / chart for the column A and column B. Column A has headers and B has the data that I want to represent in the graphs. The real problem in this is that the two columns length is not fixed. For eg. for January Column A & B could have 5 rows of data but for February they could have 10 rows of data. I dont want to prepare the chart manually every month. I want that if we could apply any VBA coomands that could prepare the chart automatically irrespective of the rows count.
View 9 Replies View RelatedI've got 100's of different graphs the problem is i'm currently manually updating them all, a simple example of the data is: ....
View 9 Replies View RelatedI have an excel sheet populated with loads of values. There is a space between each set of data. I need to draw a graph for each section and i cant work out how to do it. I have attached the sheet in question. The gap between each column has "space" written on row, which is needed to prevent it being deleted. The drawing of the graphs needs to be automated as there is going to be 100's of sheets containg lots of data. The column size of each section can change so it needs to be dynamic. I have attached an example sheet
View 5 Replies View RelatedUsing Excel 2007. Is there a straightforward way to do a waterfall chart?
eg. stacked bars running from left to right.
First Column = 2011 Headcount
2nd Column = stacked bar with additions (by category) - stepping up from the 2011 total.
3rd Column = stacked bar with reductions (by category) - steppind down from the first column + 2nd colum total.
4th column = 2011 exit (which will be at the same height as the bottom of the 3rd column).
I am using Excel 2010 to create a simple chart. When I enter the information, highlight it and select a chart, the chart area appears blank. It doesn't matter what kind of chart I choose- it still appears blank. I've tried going into the Advanced options and indicating for All objects to be shown and that didn't work.
View 1 Replies View RelatedI need to make a macro that creates a specified number of graphs depending on the file's number of data sets. I know the number of sets that are in the data, and I know the number of data points that were taken. Here is what I have:
Sub Graphs()
Dim Startpoint As Integer
Dim Endpoint As Integer
Dim count As Integer
Dim xStart As String
Dim xEnd As String
Dim NumberSets As Integer
Dim yStart As String
Dim yEnd As String
Dim DataSet As Integer
Dim Data
Startpoint = 11 'The first set always starts in row 11
Endpoint = Range("L4").Value + 10 'Thefirst set always ends after the value of L4+10
NumberSets = Range("L7").Value 'number of times I need the loop to work
count = 1..........................
how to create a stacked bar & line graph together.
I know by default, I can choose to have a stacked bar, OR a line graph, OR a basic bar & line graph.
But I need to take a step further and have a stacked bar WITH a line graph.
options in which I could combine the above graphs?
i have a stacked bar chart, similar to this: [URL] What i need is a trend line, similar to this: [URL] that shows the average of the bottom bar to date.
View 14 Replies View RelatedWe are trying to create a stacked bar graph with an average line. Each time we try to add in the average data to the graph it adds it to the stacked bar. The stacked bar should represent the inpatient & outpatient cases at a hospital for the current year (months showing across the as columns). The line should represent the previous 2-yr average total. Anyone have an idea how to add a line to the stacked bar graph? It has us stumped.
View 3 Replies View RelatedI would like to make a graph in Excel, where I present both a stacked column and a line with two different axes. Including a clustered column and a line in the same graph with two different axes is easy, as this combination can be found in the custom types selection in the chart wizard. However, there is no such alternative as a stacked column and a line with two different axes. Is combining the two manually possible?
View 2 Replies View RelatedI've been using a VBA code to look through my spreadsheet and find any graphs in any tab and move it to powerpoint. I have about 70 tabs with 7 graphs each.
I have is that the order of the graphs in the slidepack isn't in the same as found on each excel tab.I also tried renaming them (chart1-chart7) but problem still remains.
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 RelatedHere's a sample of a chart that I want; However, I want the bar chart to be a stack chart as I have multiple "Failure modes" per month that I want to show the number(or count) of failures per month. Then I want the line chart to remain the Complaint Rate for that month.
I just can't seem to figure it out.
This chart pulls from a data set that looks something like this: ....
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
I am trying to show some trends, from data taken on a monthly basis. The attached spreadsheet is an example of what I have:
The first two columns show data for Month1. The next two columns show data for the last 2 months (Month1&2). I was thinking of using a line graph, and showing Month1 and Month1&2 on the X axis. At time Month1, I'd have 4 different data points, for hw, sw, fpga and chip. At time Month1&2, I'd show the cumulative data for those same 4 categories. Over a period of time, we could see whether one area or another (hw, sw) keeps getting worse. How can I do this via pivot table?
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.
Plotting of bar and line graphs given an arrays of x and y values in VBA? I want to plot the rDateRange and rOEERange.
Code:
Dim rInitialDate As Range, rFinalDate As Range, rDateRange As Range, Calculation As Worksheet
With Worksheets("Calculation")
Set rInitialDate = .UsedRange.Find(What:=DateValue(InitialDate), After:=.Cells(1, 4), LookIn:=xlFormulas, LookAt:=xlWhole, SearchDirection:=xlNext, SearchFormat:=False)
[Code] .........
Has anyone seen this problem before;
I used a "MID" formula to extract some data and for some reason the chart I'm trying to use won't recognize the data. Here is a copy of what the data looks like. Non of the vaules will show up on the chart.
DPJE2DD2CE2CJan1.2784.8984.8997.65Feb1.2697.6597.6591.79B10==MID(B$3,8,5)Mar1.3091.7991.79154.7Apr1.28154.7154.7147.6May1.29147.6147.687.78Jun1.4387.7887.78112.6Jul1.39112.6112.6115.2Aug1.42115.2115.293.6 Sep1.3393.6 93.6 138.9Oct1.28138.9138.9NovDec115.6YTD1.32115.6115.6
I have made two line charts from a selection of data and added "shapes" to fill certain areas under the lines. Is there a way of doing this within the chart rather than adding a shape over the top?
View 3 Replies View RelatedI 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 RelatedI have two line charts in Excel 2007.
One chart has the values going down from upper left to lower right
The other chart has the values going up from lower left to upper right
Is there anyway to merge these charts to see if they intersect at all?
I have created a line chart that plots weight of a person, but want to show on the plot area what a certain range of weight represent, Ive attached images to show this concept.
View 4 Replies View RelatedHow I could create a chart (standard column) with an average line in Excel 2010?
View 4 Replies View Relatedi have attached a sheet where I have 4 graphs on one sheet. I prefer this to an overlay. I would like to add a 5th graph but it would make all the the graphs too small. Is there a way to make the graph background longer. For instance, extend the length of this so that I can put multiple graphs on it and then just scroll from top to bottom to review them? Also, how do I copy and paste these individual graphs into a newly created graph. copy/paste doesn't work on these?
Boiler.xls‎