| Thread | Last Post | Replies |
|
| Dynamic charting | 26 Oct 2006 23:00 GMT | 2 |
I have a scatter chart (curved lines) that are based on data in cells a6 through v10, with column "A" being the 4 series names and row 6 being temperatures. The user inputs a temperature that goes into b6, and the rest of row 6
|
| Formating data table in chart | 26 Oct 2006 22:15 GMT | 2 |
Is it possible to align to the right numbers in a data table added to a chart? Numbers seem to be centered and I can't find how to change the format. Thanks, MB
|
| Labels placed under stacked column chart | 26 Oct 2006 21:28 GMT | 1 |
I have a stacked column chart where I would like the labels of one of the series to always be placed under the column. Is there a way to do this automatically instead of manually moving each label?
|
| set x-y crossing on graph automatically | 26 Oct 2006 21:17 GMT | 1 |
Maybe this is a better place to have posted the question. I have a graph set up where an input starts the range you want to look at. I always want the "Y" to start at 0, and the scale nicely goes as high as necesary for the numbers in the table (viscosity). If I want to look at the
|
| Align Line Charts By Milestone Dates? | 26 Oct 2006 21:14 GMT | 5 |
I'm a chart neophyte. I have a worksheet with multiple line charts, each line depicting total hours per month per project. I would like to align the lines to a common milestone, like "start of
|
| Chart Wizard Data Source | 26 Oct 2006 21:03 GMT | 1 |
The cells in Column A (A1:A168) have a Data Validation list that allows the user to select 1 of 5 names (e.g., Bob, Tony, Sue, Mark and Mary). I would like to use the Chart wizard to create a pie chart to see how many times the various people were selected (e.g., Bob 65%, Tony 12%,
|
| How do I get a pie chart to recognize a negative number? | 26 Oct 2006 20:59 GMT | 3 |
I need to make a pie chart that has one part of the pie as a negative percentage. Does anyone know how to get my chart to recognize this negative number?
|
| Why doesn't the code create a column stacked chart? | 26 Oct 2006 17:27 GMT | 3 |
Hi again...im sorry to ask for help so much, but charts vba is tricky .. I try to create a column stacked chart of three bars containing each three different values, much like Andy Pope's
|
| Copy Chart and PasteSpecial | 26 Oct 2006 15:01 GMT | 2 |
Why does the Copy line take so long when running this code?. I'm trying to copy a chart and paste special to another workbook. When the code gets to 'Selection.copy', the computer hard drive makes a lot of noise and it takes up to 10 seconds just to complete the copy. Any ...
|
| Formatting Labels Using Code | 26 Oct 2006 14:14 GMT | 2 |
I have a stacked column chart based on data as follows: 2005 Exchange Volume Inflation Price Blank 1,862 1,844 1,844 2,210 Up 0 93 0 402 0
|
| Keep Pivot Table Chart Format unchanged | 26 Oct 2006 13:58 GMT | 3 |
I want to keep changes to format i performed in a pivot chart, that would not be affected upon refresh table. thanks\
|
| Question about Dynamic Charts | 26 Oct 2006 03:07 GMT | 3 |
Using the examples found at http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html#BasicRange I was able to create a dynamic chart as shown. However, does anyone know of any examples where the data is row based (as opposed to column based?)... I had difficulty ...
|
| Combine Clustered Column Bar charts and Stacked column bar charts | 26 Oct 2006 02:44 GMT | 1 |
Is there any facility in excel to combine two sub-chart types in excel? Regards Richard
|
| limitations to charting functionality | 26 Oct 2006 02:43 GMT | 1 |
I wonder if anyone has some work-arounds for some of Excel's more annoying limitations re: charts. (1) It seems that the Title text box cannot be resized manually, even though the usual 8 grab handles appear on the fuzzy border when the Title is
|
| Whole numbers to big for Graphs | 26 Oct 2006 02:10 GMT | 7 |
I have a number of different worksheets that I input data to for different periods. My number 1 sheet has my graph and data table that I print for my report. All my sheets are set to automatically link to my number 1 sheet. My problem is that in one of my worksheets I am using ...
|