Double Stacked Bar with Line Chart
Hello all,I believe I'm trying to accomplish the impossible, but I'm hoping someone might have an answer.I'm trying to create a double stacked bar chart, with a line chart. I've managed to create a double stacked bar chart, but I can't get a line chart. I want the line chart to straddle the groups.If you create a Stacked Bar chart with a Line Chart (on second axis), you'll see what I'm trying to accomplish. Just imagine 2 stacked bars instead of one.Like I said, trying the impossible.Here's the data setup I've got for two stacked bar charts..
Finding a line intersect
I have a chart with a number of intersecting lines. Can Excel or a pluginshow me the XY values of the intersections?Mike Hi Mike,Maybe this will help.http://www.andypope.info/charts/intersection.htmCheersAndyMike Lipphardt wrote:> I have a chart with a number of intersecting lines. Can Excel or a plugin> show me the XY values of the intersections?> > Mike> > -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info..
How do I add an extra line to a line-column chart?
Excel 2003.I have 3 sets of numbers.2 sets I want plotted as lines. (These are upper and lower limits of monthly performance)The third set of numbers is represent an actual performance; I want this set represented as columns.Each set is plotted monthly. (i.e.: x-axis is months of the year.) Make a Line chartRight click on one line in chart, use Chart type, make Columnbest wishes-- Bernard V Liengmewww.stfx.ca/people/bliengmeremove caps from email'moose' <moose@discussions.microsoft.com> wrote in message news:158D7628-6878-4BBA-8D64-5CD07CA81730@microsoft.com...
Grid lines not printing
I've got a weird one here--one of the people I support has an issue where a spreadsheet they are trying to print always prints without gridlines. THe gridlines show up in print preview, and print fine from other machines. I can't find anything in the Excel options menu that seems to apply. Any ideas? Pat wrote> I've got a weird one here--one of the people I support has > an issue where a spreadsheet they are trying to print > always prints without gridlines. THe gridlines show up in > print preview, and print fine from other machines. I > can't f..
Why does typing jump up several lines?
I am editing a long document, and when I am typing in new information, in the middle of a word, the typing jumps up to another line in the document. I have also experienced a total loss of information. This problem is quite frustrating. Laptop? This is usually an indication of an over-sensitive touch pad. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> ..
Deleting a space between a group of Numbers & Letters in a cell
I'm trying to delete a single space between a group od items:ACE 12408 ------------I'm looking for ACE12408I have over 10,000 lines so I'm looking for a shortcut...Help ME please!!!Thanks Highlight the text, go to Edit | Replace. In the Find what box just press the spacebar and then click Replace All, ie don't put anything in the Replace with box. -- Rae Drysdale'Melissa' wrote:> I'm trying to delete a single space between a group od items:> > ACE 12408 ------------I'm looking for ACE12408> > I have over 10,000 lines so I&..
Removing blank lines
I have been deleting numerous lines of my database, but I am left withblank spaces.Is there a way inwhich all the blank spaces, which there are hundreds,can be removed by one click, with the following lines underneathfilling each space?Thank you-- Timeferret------------------------------------------------------------------------Timeferret's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19170View this thread: http://www.excelforum.com/showthread.php?threadid=490668 Filter the data (Data>Filter>Autofilter), select blanks, and delete allvisib..
Search SOP Sales Line Item Comment Lines
I am trying to use Smartlist to search the SOP sales line item comments. I can find the SOP Document comments, but how do i link the Sales Line Item Comments to a SmartlistDebbie Debbie,I don't see the sales line item comments as available fields in the Sales Line Item SmartList. I see Comment 1, Comment 2, etc., but those are bringing in the comments from the SOP Transaction (header), not the line items. I don't know if that is by design or was overlooked. In any case, doesn't look like there is a way to bring those in without using SmartList Builder at this point..
Crop white space on chart
I created a chart and got it the right size so it can fit on the page. However, there is about four inches of white space that I cannot get rid of. If I decrease the size of the whole chart area, it changes the size of the graph, font included. The only method I know how of getting rid of the white space is increasing the size of my graph but it does not fit on the page anymore. I DO NOT WANT THIS TO HAPPEN.Ideally, I would like to 'crop' out the white space of the chart area without affecting the size of my graph.Please help!!!! This is so frustrating :sThanks so much...
Adding an average line
I was adding an average line like thisSeries 1 Series 210 average(series1)=2520 2530 2540 25and plotting the average line.I then tried plotting a linear trendline, with the 'set intercept' set to the average (25). However the lines were not always perfectly horizontal (I can't understand why).Is there a way to create an average line? basically I want to write y = averagevalue'Gaijintendo' wrote:> I was adding an average line like this> > Series 1 Series 2> 10 average(series1)=25..
Line break in custom date format?
I want to display the date like this: Ddddd, MM/DD/YY For example 'Monday, 12/08/2009'. However, I want a line break after the comma so that the spelled-out day and date are on different lines in the same cell. It's harder than it sounds. In the cell, the value is '12/08/2009'. But the format makes it display as Monday, 12/08/2009. I can't just put an alt+enter in the middle of the date value, as that value would no longer make sense. Is there a code I can put in a custom format that will allow me to insert a line break? Thanks, Much. You..
2 axis chart stacked bar next to bar with line
I am looking to create a 2 axis chart with a stacked bar next to a bar with a line over them. Example: Plotting by year (x axis) as stacked bar sales by product line in $ (y axis 1), the bar next to the stack for each year is total company profit in $ (y axis 1), the line would be the number of housing units started in the year (y axis 2). Hope this is clear enough. Take a look at Jon Peltier's site and see if you can find something like what you want. -- HTH,Barb Reinhardt'SuLu85' wrote:> I am looking to create a 2 axis chart with a stacked bar next to a ba..
copy a formula over two rows but increase the row # by 1 only
How do you copy a formula from one cell in row 'a' to row 'c', but only increase the row reference to 'b' automatically? Dave,Copy it to row 'b' then drag the copy from 'b' to 'c'HTH,BernieMS Excel MVP'Dave' <Dave@discussions.microsoft.com> wrote in message news:5F8E96F9-15A7-4742-AC0D-40A0D64F14D9@microsoft.com..> How do you copy a formula from one cell in row 'a' to row 'c', but only> increase the row reference to 'b' automatically? Rows are numbers, columns are letter..
How do I get my Excel time-line column chart to display in color?
I have Excel 2002. I am trying to create a clustered column chart with a time-scale x-axis. It seems to create the chart, but it limits it to black and white, with skinny little columns that you can hardly distinguish. As soon as I eliminate the dates along the x axis, it turns into technicolor. But that isn't what I need. Help! i am having excel 2000. if you point cursoron the bar and right click youget <format data series>on the left side click custom and click color andchoose color and ok it seewhether you get what you want.Father Garrin <Father Garrin@discussi..
Off line data stuck! The last straw..
During a long and painful support case, I had to change the organization’s name.While I was getting my system back in working order after $750plus support calls, I had a large number of off line users entering a lot of work.These users now are unable to go online. (None at MS during this time suggested to make sure that my users will NOT enter any data, since they will not be able to go online after we change the org name!)I have changed the relevant entries in the registry for CRMCLIENT, but still not able to get on line.How do I get my off line data synced up now??? I assume the..
One line is coming out Thinner then the others when printed
Why does one line come out thinner (not as dark and thick as the others) when i print the final document- the lines are all the same 'Weight' as in 2pt- can any one help Have you selected the Bold on the tool bar?-- Don - Publisher 2000�Vancouver, USA'Advice First' <Advice First@discussions.microsoft.com> wrote in message news:773726D4-927E-4DB6-90C5-05B9B11459EF@microsoft.com..> Why does one line come out thinner (not as dark and thick as the others) > when> i print the final document- the lines are all the same 'Weight' as in 2pt-&g..
Linea increase
I have been using IF statements but specific values are not accurate enough. I want to increase my initial value gradually. I.E between 50 - 100 increase values by 5 to evenutally 0 so 50 would become 55 and 100 would stay 100. I require a linea increase to improve accuracy. If you write e.i. 100 in A1, then remember to use the '$'-sign around A and 1. You might write a statement (with the increasement of 5 and so on) and then copy the formula down to begin with. Put $A$1 in an IF statement, and it wil always refer to that specific cell. Hope you can use it - sorry my expl..
Convert Chart Line-Column to Column-Line
I am trying to convert/develop a 4series custom chart. The first & second series to show as a line, the third/fourth series as bars.Can any one help.Many ThanksGeorge George -Next time don't use the built in custom chart type, because it'll do this whenever you add data. Here's how to make your own combination chart.Select the data, and make a standard chart that matches the type you'll use for half the series (e.g., a column chart). Select a series you want to change, choose Chart Type from the Chart menu, and choose the other type (a line). These won'..
Problem adding a vertical line to a graph with months on x-axis
I'm trying to add a vertical line that would indicate the currentmonth, i.e. May 2007, to a graph with a Line and a Stacked Area, andmonths (e.g. January 2004 through December 2007) instead of days onthe x-axis. I've tried different variations ofhttp://peltiertech.com/Excel/Charts/AddLineVertSeries.html, withoutsuccess. Any suggestions? What isn't working?Is your X axis a time-scale axis? You need to use the corresponding date as the X values of the XY series that controls the vertical line. In the time-scale axis, is your Base Unit days? Then you can use the date you wa..
Grouping on the same line
Hi - I am trying to create a report and need to use grouping. Is there a way to have groups on the same line versus staggered below the one before? For example - current state: A B 1 2 3 Desired: A B 1 2 3 Thanks so much! It is possible. Post table and field names with datatype and sample data. -- Build a little, test a little. 'Erin' wrote: > Hi - > I am trying to create a report and need to use grouping. Is there a way to > have groups on the same line versus staggered below the one before? ..
Inserting A Blank Line?
The following data is imported to a worksheet using a macro. Is it possible to insert a blank line between each header? The amount of data varies between headers and total.1:40Folkestone 9 Apr 2009 Maiden (Class 6) 5f 14 RunANJOMARBAOUR GEORGIE GIRLRUFUS ROUGHCUTDIAMOND AFFAIRSAACHIS VISIONDIAMOND LAURA1:50Wincanton 9 Apr 2009 Novice Handicap Hurdle (Class 4) 2m 18 RunQUINY BOYTENOR DE BALMEGRAND ARTICLEWESTSTERNSTAR TENORJOCHESKIWUJOODGAINSBOROUGHS ARTHIGH CAROLLEPIDOBID ARTRUBY VALENTINENESOTHO2:10Folkestone 9 Apr 2009 Handicap (Class 5) 6f 12 RunRARE ARTSHADOW B..
Determining error associated with polynomial trend lines.
I have a plot that requires a polynomial trend line to the fourth power that has error associated with the y-axis values only. From this point on, I'm relying on the equation displayed by excel to further manipulate that data, which I have done and double checked with excel and it's corrrect. I'm having difficulty, however, in continuing the calculations of associated error. Is Excel capable of outputting the error associated with each coefficient of the generated trend line equation? If it is possible, how do you do it?- BJR See Help for the LINEST function. You mig..
Need to create the character that means 'with'.C with a line over
Can anyone help me? I need to create the character that means 'with'. It is displayed as a c with a line over it. I have looked in symbols and windings and can not find the character..
Drawing a line on a chart
Help! I need to draw a line on a chart that is horizontal - - in old Excel, the SHIFT key could be used to 'snap to' the horizontal, but in Excel 2007, it does not work and it is driving me crazy! Not sure what you mean by 'snap to' Holding SHIFT while drawing the line will keep it horizontal but I cannot recall in Excel2003 that you were able to fix a line that you had already drawn - my PC will XL2003 is out of commission today so I cannot confirm this. I have just experimented with XL2007 : holding SHIFT does indeed keep the line horizontal Try again on ..
Error when create chartobject on line '.HasTitle = True'
Hi,I gett runtime 1004 at line 'HasTitle = True'The peculiar thing is that yesterday it worked ok. I saved it, slept,and now I get the error. I have tested to put the Has title ocde in theend of the sub, after seriescollections etc, but with same results.Any ideas, anybody?/Kind regardstskogstromSub CreateChartCF()Dim cht As ChartDim chtTitle As StringchtTitle = 'CashFlow & PayBack'On Error Resume Next '(if no chartobject)Sheet2.ChartObjects('R_CF').DeleteOn Error GoTo 0If Sheet1.Range('Years').Value > 1 Then With Sh..