Unable To Update Line Chart?
Feb 21, 2014I had a couple of days ago..
I can get the "Daily %" to update just fine but for the life of me cannot get the "Total Number of Patients" to update.
ADVERTISEMENT
Unable To Update Data Used By Function
Jun 1, 2006I have a function written in excel written in VBA. The function reads data from a worksheet and uses it in an array to solve based on the variable passed with the function. Now the issue is if I change variable that the are passed with the function it works fine. If, however I update values in the worksheet that the function is using as an array (sort of a look up table) the function doesn't see the change. I have to exit Excel and reopen it to get it to re calculate the function. Is there a better/faster way than continually closing and reopening excel?
View 3 Replies View RelatedExcel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart
Nov 27, 2011I am looking for a creative way to display a pie chart within a data point marker of a line chart.
My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)
I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.
I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.
The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)
the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.
I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.
Adding Comparison Line Chart To And Existing Population Pyramid Chart
Jul 14, 2012I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.
View 1 Replies View RelatedShow Missing Values In Pivot Chart (line Chart) Axis?
Apr 18, 2013How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
View 1 Replies View RelatedExcel 2007 :: Unable To Set Pivot Table To Manual Update?
Aug 19, 2013I am using Excel 2007 and my version of visual basic is 6.5.
I am baffled by the behavior of this code to manipulate one of my pivot tables. I am trying to set all but one of the pivot items in one of the pivot fields to not visible. Because there is a large number of items, I wish to suspend all automatic updates until all items are properly set to visible or non visible.
------------------------------------------------------
Sub SwitchBoards()
Dim BoardNew As String
Sheets("Board Parameters").Select
' Make sure we get the right value.
[Code].....
The MsgBox returns with: "Manual update is set to False" right after the instruction to set it to True!!
Overlay Line Chart On Top Of Stacked Column Chart?
Feb 15, 2012I 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 RelatedLine Chart - 12 Month Chart Moving With Dates
Jan 22, 2008Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.
The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.
Column Chart With Line Chart And Percentage?
Sep 15, 2014In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.
View 3 Replies View RelatedPareto Chart, Set Line Chart Origin At Zero
Nov 28, 2008I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.
Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.
Line Chart To XY Chart And Vice-Versa
Feb 5, 2010Attached is the sample data worksheet. Chart 1 is XY type chart using Seconds (2nd column of sample sheet as x-axis from 42510 to 42530). How do I change it to Line chart using Time (1st column of sample sheet as the X-axis) retaining same data from 42510 to 42530 on both primary and secondary axis?. And how do I again change it back to XY chart?
View 3 Replies View RelatedUnable To Create Simple Win / Loss Chart
Dec 4, 2012I have a # of games played column (Column A), a # of games won column (Column B), and a number of games lost column (Column C).
I'm trying to make it so Column C automatically enters the number when I put in the number in Column B.
Example:
Games Played........Win........Loss
1.........................1...........0
2.........................1...........1
3.........................1...........2
4.........................2...........2
For the fifth game played, if I won it, how do i make the 2 to automatically enter into the loss column when I put in the number 3 in the win column?
Excel Pie Chart - Unable To Use Sums For Fields / Axis?
Aug 4, 2014I have a set of data for hours of work. I want to make a simple Pie Chart: % of Hours worked overtime, and % of work not overtime.
The Data Looks something like this:
Name,Normal Hours Worked, Overtime Worked
David,8.0,3.2
Anne,8.0,1.3
Danny,7.0,0.0
Harry,8.0,3.0
Edward,8.0,2.3
So I want a pie chart that has 2 wedges.
~25% labeled as overtime worked
~75% labeled as normal hours worked
Whenever I put these values in the pivot table and use SUM, it is trying to sum based on # of hours matching, instead of by the column Name... so it gets divided into a bunch of different pie wedges.
Copy Charts From Excel To PPT - Unable To Resize And Format Chart
May 23, 2014I have an excel which creates PPT from the excel. but the graph pasted in PPT are not aligned and formatted.
By aligned, i mean re-size the graph and paste in a formatted fashion (currently they are overlapping each other)
My entire PPT created is off alignment and formatting. E.g heading are not properly aligned (they are touching the line below) and so on.
A Chart Will Columns And A Line Chart Below??
Dec 15, 2007I can create a column chart in excel comparing sales in 06 v's 07 for each month in 07, what I'm aiming to show on the chart is how sales have grown or not over a comparative period. A simple enough graph, I end up with about 24 columns (2 for each month and then a gap between each month).
I now want a line chart to show the performance of an index over the same time period, lets say the FTSE100.
I don't know how to get the line chart under the columns on the same graph, using the same x-axis with a small y-axis to the left. I could propably figure out the y-axis bit if I could only get the line chart below the columns.
Insert Line & Update Macro
Jul 3, 2009I have created this macro below however if on the worksheet I insert a line or lines the macro range G25:G107 does not change - it remains static.
How can I get an insert of a line to increase the macro range by the number of inserted lines. For example if I insert 2 lines then the macro range s/b now G25:G109.
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
Nov 1, 2006I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:
1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.
2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.
3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).
What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.
Macro Request - If Macro Is Unable To Perform One Of Its Jobs Then Move Onto Next Line
Oct 3, 2012I have a macro which refreshes a query when the spreadsheet is opened. This works fine when online.
However, if the user is not online, the query is unable to refresh and the macro just hangs.
Is there a code which will enable me to say " if unable to refresh then move on to the next line"?
here's the code below.
Private Sub Workbook_Open()
Sheets("Houselist").Activate
Selection.QueryTable.Refresh BackgroundQuery:=False
Sheets("Front").Select
Range("A1").Select
End Sub
Line Chart To Zero (VLookup)
Apr 7, 2014I have a couple of charts getting their data from a vlookup formula, example,
=VLOOKUP($A$8,CPPDATA!$A$4:$O$27,5,FALSE).
I really need to prevent this from happening. I'm sure there is a way.
see image
[URL]
0 Value On Both X And Y Axis In Line Chart How
Jan 4, 2008i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs
How Do I Not Graph A 0 Value On A Line Chart
Oct 26, 2009I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?
View 9 Replies View RelatedLine/candlestick Chart
Apr 28, 2007I am trying to graph a candle stick chart but also have a series which is a line in the graph. I have attached the file. I am trying to figure out how to get get column E as a line in this graph.
View 4 Replies View RelatedR Squared In Line Chart
Jul 27, 2007Hi, as you can see in this chart I am plotting TOTAL company sales against its three merchandise components - men's, women's, and accessories. My issue is that when I had two rows to just show company sales against one of the merchandise categories -- and I Go TO TRENDLINE and show the R-Squared, it is ALWAYS THE SAME= 20%. CLEARLY, something is wrong beacuse (a) its different numbers for each of the three merchandise categories and (b) these three categories make up the total comp so CLEARLY it should be a higher R-squared than 20%. How Can I get it to properly read the R-Square.
View 9 Replies View RelatedBar-line Combination Chart
Sep 28, 2007I have a table with 7 rows and 7 columns:
First 6 rows - months i.e. Mar to Aug
7th row - Average no. of Breakdowns
Colums - Mon to Sun
I am trying to create a bar-line chart with the 'Average No. of Breakdowns' to be on the 2nd Y-axis and displayed as a line.
The rest of the data would be on the primary Y-axis and displayed as bars,
But I am unable to get what I want. Instead, the data on the 5th and 6th row is displayed as lines. I even tried formatting these 2 rows to the primary Y-axis but they are still displayed as lines.
Add Line To Chart To See Trend
Dec 5, 2007On top of these graphs, i draw a line (insert a line shape) corresponding to a certain gradient in the data presented. I do not want this line to be exact (i.e. not point to point) as it is best to be drawn by eye so that the general 'gist' of the data can be found. What i would like, using any method available, is to be able to find the gradient of this line i have just drawn which obviosuly must be done taking into account the scale of the graph. The scales of the graph will not be consistent across all applications.
View 4 Replies View RelatedConvert Data To Line Chart?
Oct 10, 2012I know how to create a chart that is linked to another worksheet without a problem.
What I'm looking to accomplish is to create a line chart that automatically updates when new data is entered. So if I were to enter data for October 2012 it would automatically update the chart without me having to manually select the data. I tried the OFFSET tutorials and to be totally honest I get lost so maybe can give me a step by step? Also, I only want to have 15 months of data to show on the line chart at one time. So it should show June-11 to Sept-12 to begin with and once data is entered for October (R) it should update the the line chart to show only July-11 to Oct-12.
I messed with it for about 5 hours last night and got nowhere. About 2 hours today and even watched YouTube tutorials. I can almost get the OFFSET but it's a vertical OFFSET. I tried the horizontal tutorial but it still selects vertically.
Bar Chart With Trend Or Average Line (XY)
Jun 24, 2014I've created a graph from data and need to add an average/net impact/trend line to the graph. From what I've read this needs to be an XY scatter, however, several efforts later and I can't seem to get it to work for me.
0514_Costs_DRAFT_ExcelF.xlsx
Bar Chart Appears As Thin Line Instead Of Bar
Mar 20, 2014I am in the process of developing a tool to generate Bar charts for a set of metrics data. PFA the screenshots for the bar charts. enough spacing is needed in the bars.
ActiveChart.ChartType = xlColumnClustered
i had also axes.group=2 secondary axis.
Line Chart - Y Axis Break Between 0 And 0.8?
Aug 5, 2014the y-axis break between 0 and 0.8.
View 3 Replies View RelatedAdd High / Low Points To Line Chart?
Aug 23, 2013How to add high/low points to a line graph, similar to what sparklines have. The file I am using now doesn't allow me to add new columns of data, so I'm trying to figure something out that just updates dynamically using the data I already have in place.
This page has the thing I want to do, but it requires additional columns to be added to work, which I don't want:
Excel - Show High/Low Points on a Line Chart