| Thread | Last Post | Replies |
|
| Edit X Axis Range for Bond Pricing | 28 Feb 2010 10:01 GMT | 1 |
I am trying to chart bond pricing and am having trouble getting an accurate graph. For example, bond pricing maxes out at 100.310 before resting back to 101.000 and counting back up. So when pricing goes from 100.310 to 101.000, it really is not much of a change, but the graph ...
|
| 2 axes charts in Excel 2007 | 28 Feb 2010 01:51 GMT | 1 |
Has anyone ever received or know of an update to correct the very problematic behaviour of Excel 2007 when (trying to) produce charts with 2 independent axes, each with manually set limits? The program regularly goes off in to a real huff and becomes unresponsive for absolutely ...
|
| Performing A break even analysis | 27 Feb 2010 18:48 GMT | 1 |
I am trying to peform a break even and sensitivity analysis using an input area, data chart and a chart to present the information. I have fixed costs, variable costs (one in each that are combo boxes that I change) and a selling price that is variable. ANY guidance on doing ...
|
| How do I partially fill a plot area with color? | 26 Feb 2010 17:48 GMT | 1 |
I have charted two learning curves... the curves are basically parallel with one another... one is just slightly higher than/above the other. I want to fill the area below the lower of the two curve with one color; the area above the higher of the two curves with a second color; ...
|
| how to create a stacked bar chart | 26 Feb 2010 17:45 GMT | 1 |
Defect Code Part No. Defect Qty 206 A 2 221 B 1 221 C 1
|
| Column chart - data labels problem | 26 Feb 2010 14:23 GMT | 4 |
I'm developing a chart for a client who has very specific requirements. The data is of the following type of info: Q1 2009 Q2 2009 Q3 2009 Q4 2009 YTD 2009 Alpha 3.3% 53.3% 18.8% 9.5% 105.8%
|
| Can you change a horizontal bar chart to start at the right | 26 Feb 2010 02:39 GMT | 1 |
I want to change a horizontal bar graph to start on the right and go left instead of the traditional left to right. Can this be done? If so, how?
|
| Graph does not copy with the tab | 26 Feb 2010 02:29 GMT | 3 |
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 ...
|
| Excel is adding 2 rows of data source together when charting | 25 Feb 2010 20:30 GMT | 1 |
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 ...
|
| Positioning x axis at bottom of chart with negative values | 25 Feb 2010 15:13 GMT | 5 |
Im using Office 2007 and have a simple line chart with negative values on the Y axis. I have ticked the 'values in reverse order' on the Y axis but the X axis flipped to the top of the chart. How can I keep it at the bottom please? Thank you
|
| How can I add a chart on my user form ? | 25 Feb 2010 03:49 GMT | 1 |
Would you please help me, I need to add a chart on my user name! Thanks in advance
|
| Excel 2007 crashing with simple scatter plots with 8 k data points | 25 Feb 2010 01:55 GMT | 7 |
I am having a real problem with Excel 2007 (and PowerPoint 2007) when trying to manipulate very basic scatter plots (two series, smoothed lines, 8000 data points per series). When I try selecting one of the series, Excel goes off in a huff for about 20 or 30 minutes (I am not ...
|
| Am confused about a simple data layout- need help asap! | 24 Feb 2010 23:11 GMT | 1 |
This is really silly, because I am good at charts, but for some reason, I cannot formulate in my head the proper layout of this chart. Here is what I have/need: THESE ARE MY DATA HEADERS:
|
| do not chart rows with no information | 24 Feb 2010 17:24 GMT | 4 |
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
|
| Excel 2007 - VBA - set xaxis orientation | 24 Feb 2010 15:58 GMT | 2 |
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?!
|