| Thread | Last Post | Replies |
|
| stacked column chart with line or points | 10 Mar 2004 17:00 GMT | 3 |
Hello! I am trying to create a stacked column chart with 2 sets of data in each stack and add a line (or points) for a third set of data. My data is set up as indicated below and will have all 24 months of data when completed. There should be a stack for the Jan 03 TOTAL ...
|
| Bars on secondary axis are on top of primary axis bars | 10 Mar 2004 13:55 GMT | 2 |
Hello - any help on this would be appreciated: Scenario: I am trying to create a bar chart with a secondary axis. One axis needs to show number of employees and the other
|
| Price & Volume: Secondary X axis Question | 10 Mar 2004 13:51 GMT | 2 |
I created a typical price&volume graph. Price/XY, Volume/Column. I put Secondary Category (X), Category in order not to break columns. Q. How could I change Volume's color (on Secondary X
|
| Excel Pie Chart - labels overlapping | 10 Mar 2004 13:29 GMT | 1 |
I have a Excel pie chart that is populated with dynamic data. When th data changes, the labels on the pie chart move. This means that many o the labels are overlapping, and some are even off the viewable area Does anyone know how to stop this from happening
|
| one trendline from two row ranges | 10 Mar 2004 13:25 GMT | 1 |
Hi MVPs, A1:IV1 keep day's high and A2:IV2 keeps day's low. How may I have one trend line using these two rows? Thanks for your help
|
| HELP please | 10 Mar 2004 13:12 GMT | 1 |
I have a list of grades for my classes marks on how well they ar perfoming in certain sections of their Coursework. I need a line grap to show how everyone in class (21 people) is comparing against eac other, but i need it to update when the marks are changed, but keep th
|
| Text on Y-Axis | 10 Mar 2004 13:04 GMT | 1 |
I'm trying to get text as a value on a bar graph. The data is similar to the following. Sunday Monday Tuesday Wednesday Brown White White Yellow
|
| Using a variable for worksheet name in SERIES | 10 Mar 2004 13:01 GMT | 3 |
I am trying to reference a dynamic range in my code that modifies a existing chart SERIES statement. However, whenever I enter the dynami range name (i.e. rngACWP) Excel inserts the workbook file name i addition. I have tried referencing the sheet name...which didn't work
|
| Graphing occurances of conditions over time | 10 Mar 2004 12:56 GMT | 5 |
I attempted to post this yesterday, but the post doesn't seem to have been made. Apologies if I'm being stupid and missed it I'm attempting to chart a scatter graph on data in excel 2000. The data is organised in a database style table. Each record (in rows) covers the occurance ...
|
| named ranges | 09 Mar 2004 22:25 GMT | 1 |
I have been trying for days to get the following to work. I hav created a chart in Excel with named ranges. I have created a range for th entire sou
|
| second category Y-Axis | 09 Mar 2004 21:33 GMT | 1 |
I have 3 series that are measured on the left-hand Y-Axis 0 to 250 scale of a line chart. How can I measure a 4th series on the right-hand Y-Axis, using a diffenet range of values, say 0 to 10 scale?
|
| Scatter Plots and labels | 09 Mar 2004 18:54 GMT | 1 |
Lets say you have a scatter plot of variable x vs y but want the label to be a different series? For example Name X Y
|
| Calendar | 09 Mar 2004 14:29 GMT | 2 |
I would like to create a calendar (somewhat like outlook) that is populated with bars when I type in start and end dates in my spreadsheet. Any ideas Thank Kev
|
| How to make a waterfall chart | 09 Mar 2004 14:01 GMT | 3 |
I have to create a Waterfall chart (not to be confused with a cascade chart) like the one shown at http://www.ozgrid.com/Services/excel-waterfall-chart.htm. This is just a one-time deal, and I don't feel like buying the add-in. I would rather learn
|
| Creating Active Spreadsheet | 09 Mar 2004 05:08 GMT | 1 |
How do you creat working sreadsheet for multiple user where each participant can make inputs to the document , the inputs gets auto saved such that the original document gets updated in- real time
|