| Thread | Last Post | Replies |
|
| error bars don't display consistently in excel | 12 Jun 2006 06:29 GMT | 2 |
I am plotting lots of similar graphs in Excel. To make a new graph, I just copy and paste the previous one and then change the source data to the new data series that I want to plot. But when I change the source data for the error bars (I am using custom data to say what size the ...
|
| Syncronise zero values | 11 Jun 2006 22:55 GMT | 2 |
I have seven columns of data to chart. Columns A & B have values aroun 500,000 to 600,000 and I wish to show them against the right hand axe as a line chart. The remaining columns have values from -50,000 t +200,000 and I wish to show them against the left hand axes as colum
|
| Making Excel charts with exactly the same size | 11 Jun 2006 14:33 GMT | 2 |
I am amking a report and I have several diagrams that I want to have the same size (exact). However, I only manage to change the size of the diagram-"bok" numerically. How can you fix the size of the actual diagram numerically (and not by mouse)? Anyone? Please need answer fast!
|
| How do you go one whole row minus another whole row | 11 Jun 2006 02:09 GMT | 1 |
How do you go one whole row minus another whole row
|
| How can i set up a 3d chart with z axis data? | 11 Jun 2006 00:04 GMT | 1 |
I need to set up a chart with x,y, and Z axis data (a real 3 d chart). Any ideas as to how to enter data into the cells and more importtantly how to crate a chart showing all values? Thank you
|
| Need to show percentage in a column chart | 10 Jun 2006 22:23 GMT | 4 |
I've created a column chart showing 2 quarterly totals - (1) Total requests and (2) Urgent requests. I need a formula that will calculate the percentage of Urgent requests in relation to the number of total requests. I checked the two (PERCENTRANK and PERCENTILE) that I found in ...
|
| Vector Perceptual Mapping | 10 Jun 2006 21:01 GMT | 2 |
How to create vector perpetual maps in excel or any other software. Regards, Swati
|
| Zeros in clumn chart | 10 Jun 2006 13:02 GMT | 2 |
Hi, How can I show zero values in a column chart?
 Signature Mifty
|
| Dragging chartsd | 10 Jun 2006 04:26 GMT | 2 |
I can't seem to drag an ebedded chart around the worksheet. Am I missing something, or is this feature broken?
|
| Filtered data chart | 09 Jun 2006 20:08 GMT | 1 |
I am filtering data based on rank, and I would like to plot the top 5 automatically on the chart. basically these ranks and their data is all linked...so i want the chart to change as and when data changes and ranks go up or down
|
| Toggle Data Label "Value" On and Off | 09 Jun 2006 19:52 GMT | 1 |
Is there any way to toggle the "Value" label for a chart on and off using a button linked to some VBA code. I'd like to be able to have the label formatted (i.e. color, size, etc) so that the user just has to click a button for the values to show on the bars of the chart.
|
| Automatic Update | 09 Jun 2006 19:34 GMT | 1 |
I have a chart I want to automatically update from now until a certain point in the future. The chart actually updates, but shows the whole time series (but not the data) on the x-axis instead of only those dates that have occurred. The data series is in rows and so the ...
|
| multiple axis in excel | 09 Jun 2006 19:14 GMT | 3 |
Maybe a simple question for you all guru's here, but until now I can't find what I want in excel.... Something I've already seen in hardcopy, but until now not in excel. I don't know the name of it, but I'll try to describe it somewhat.
|
| Automating bubble chart colours | 09 Jun 2006 16:03 GMT | 2 |
Does anyone know if the colour of a bubble within a chart can be conditionally formatted through reference to a cell within the spreadsheet ? I want the colour of each bubble within the chart to based on the result of a calculation within the spreadsheet. Currently the cells ...
|
| (Stacked) Bar/colum chart | 09 Jun 2006 12:20 GMT | 1 |
I'm trying to create a chart that will show me the 2 bars sort of on top of each other, in the same column. So for example if I have a budget value of £500 and a spend of £300. The first £300 of the colum is one colour and the remaining other £200 is another
|