Charts
in [Excel]
|
Graph does not copy with the tab I am using Excel 2007 and have a graph on the same page as the data. I want to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied ... 25 Feb 2010 23:50
Excel is adding 2 rows of data source together when charting I'm trying to create a simple chart that shows trending during the year. I have several rows of data -- 1/2 of them being actual financial performance numbers and the other 1/2 being budget numbers. When I select the data ranges, whether using the Control Key to select all ranges at once, OR by selecting them... 25 Feb 2010 15:59
How do I prevent a text box from printing in XL2007? In XL2003 I could put a text box on a chart and mark it to NOT print with the chart. Having upgraded to XL2007 I can't find how to do that and previous (2003) spreadsheets that had non-printable text boxes now print those boxes in XL2007. Can anyone help, please? -- Andrew ... 4 Mar 2010 22:33
Excel 2007 crashing with simple scatter plots with 8 k data po Dear Jon, This issue (or a very similar one) was reintroduced with Service Pack 2. I note it has apparently ben fixed in Excel 2010 (beta) but are there any fixes for Excel 2007? I have had this acknowledged as a bug by the Excel team bak inth esummer of last yeart but have nit heard anything about a fix... I ha... 24 Feb 2010 21:07
Problem with stacked column chart I'm using Excel 2003. I have basically 2 sets of data, the 1st is a total count of people and the other set is a breakdown of the total count into 5 subcategories. I have a stacked column chart with a weekly category axis that has the 5 categories and the total all in one column per week. However, the count is... 2 Mar 2010 13:34
Excel 2007 - VBA - set xaxis orientation How can I set the xaxis to an arbitrary angle, say -70 deg using vba? I recorded a macro to do this and it does not actually do anything??? Tried it 3 times. I end up with the proper layout but the recorded macro does not actually format the xaxis when run again?! QB ... 24 Feb 2010 12:01
do not chart rows with no information How do I get a chart that does not include rows of data that are empty. Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 ... 24 Feb 2010 13:10
Excel 2007 - Add straight line to chart How would I go about adding a horizontal line to a chart. I am trying to make a line chart and need to place a horizontal line at 80% across the entire chart. How can I do this? QB ... 24 Feb 2010 00:58
Excel 2007 - Chart not working First, I must say that Excel 2007 charting is much worse to use than 97, 2000 or 2003! It is not intuitive as it was with previous versions! I created a very simple line chart. The problem I am experiencing is that is start my initial value at 0%, which is fine and then promptly goes upto 100% and stays ther... 24 Feb 2010 00:58
Loss of referenced data (Titles) when upgrading from Excel 2000to 2007 Maybe it has been killed as paert of a conversion between file formats, but 2007 certainly supports the sort of thing you are talking about. If you select the chart title box, or an axis label for example, you can simply type in the formula bar what they should display, for example ="Sales figures for month of "... 23 Feb 2010 15:53 |