| Thread | Last Post | Replies |
|
| Comparing data from 2 monthly periods in 1 chart | 30 Nov 2007 14:42 GMT | 2 |
I am trying to compare 7 coloumns of data (Housing Advice Stats) from May to Oct 06 to the same set of data taken in May to Oct 07. Ideally I'd like to lay one over the top of the other so I can see the differences from one year to the next ie, have 2006 as a column chart and
|
| Keeping Custom Chart Settings | 30 Nov 2007 13:22 GMT | 1 |
I'm working with a chart generated from a pivot table. I've used a 3D chart in B&W because it will most likely be printed on a non-color printer by those who receive it. The problem I'm having is that any custom settings I use on the chart are "undone" if the source pivot table ...
|
| How do I change the size of the legend key in a chart? | 30 Nov 2007 13:16 GMT | 1 |
On a column chart in Excel each column has a different color. The name of each category is shown in the legend along with a small box (legend key) with the color corresponding to the color of the column for that entry in the chart. My question is how to I enlarge those little ...
|
| Change axis values | 30 Nov 2007 11:45 GMT | 2 |
Excel 2002. Spreadsheet chart plots a cycloid, with x=r(t-SIN(t)) and y=r(1-COS(t)). The chart produced is correct. However, I would like the x-axis to display the values of angles (either degrees or radians) rather than the values calculated by x=r(t-SIN(t)).
|
| Copy charts from 1 workbook to another | 30 Nov 2007 07:41 GMT | 2 |
I have created a macro which copies some charts from one workbook to another. It has to repeat this for several tabs of the workbook. I need to know if i need to create an object to copy n paste these charts or can it be done without an object. A quick reply is
|
| Best chart format to use? | 30 Nov 2007 01:54 GMT | 6 |
Hi, I am using Excel 2003. Let's say we want to implement a new system, and to get an idea of what to buy, we survey a number of like organisations to see what they are using, whether or not they recommend the system and if they have had any problems.
|
| How do you add a call out to your chart? | 29 Nov 2007 16:47 GMT | 3 |
I am trying to add a callout to my chart but my resource material does not cover it.
|
| Column chart with 3 orders of magnitude | 29 Nov 2007 14:47 GMT | 2 |
I would like to build a column chart with 3 orders of magnitude. I envisage this as two series plotted as columns in three parts 1) A Y-axis with Y-max = 100 and say 3 X-labels followed by 2) A change of scale with another Y-axis with Y-max = 10 and another 3
|
| Chart wizard funcitonality in Excel 2007? | 29 Nov 2007 13:53 GMT | 7 |
I hope I'm missing something in Excel 2007. In Excel 2003, the chart wizard gives you access to lots of options when you create a graph--graph type, data range, the various series (including the X axis labels), the chart title and axis titles, gridlines, legends, and others. It ...
|
| can excel automtically graph things with given data? | 29 Nov 2007 13:38 GMT | 2 |
I have to do a lab report for school and my teacher told me to go on excel and insert the data that it will automatically give you a line graph with a best-fit line. Please help me!!!!!!!!!!! Thank you
|
| Extra data plotted on chart | 29 Nov 2007 13:34 GMT | 2 |
I am charting (using Office EXCEL 2003) data from Jan05 to Sept07 on my x-axis. The resulting chart adds additional data to oct, nov and dec 2007. I have no idea where it comes from because my charting data ends at Sept 07. I did a copy/paste special from a pivot chart to see if ...
|
| Combined bar/Line graph defaults to bar | 29 Nov 2007 13:20 GMT | 1 |
In Excel 2007 I have a Combined bar/Line graph get it's data from a pivottable. Intermittently, when I change the pivottable filters, the combined bar/Line graph defaults to just a bar graph.
|
| Graph | 28 Nov 2007 20:51 GMT | 3 |
Can someone please tell me if this is indeed possible? I would like to make a graph with 2 different Y axis's. First I would like a stacked bar graph (easy on its own; the total range of this stacked graph will most likey be from 1-10). Essentially I am
|
| Difficulty Setting Up Excel Chart With Scroll Capabilities | 28 Nov 2007 13:36 GMT | 2 |
I am trying to set up an excel graph that will let me scroll through a large amount of values. I want to be able to set my range as something like A1:H501 and actually have data all the way to Row 65000. What I want to do is then have a scroll bar be manually moved and the chart
|
| Bar Graph not allowing choice of X axis | 28 Nov 2007 11:34 GMT | 1 |
I am trying to get my Bar graph to put the money in my table on the Y-axis, but it puts it on the X-axis. My table is: Response Amount 1 $200,000
|