| Thread | Last Post | Replies |
|
| Chart Legend Items: hide/show | 05 Sep 2005 15:04 GMT | 5 |
How do I hide/show a series on a chart legend (scatter plot.) I tried a null string (""), but the trace still shows. I also tried #N/A. But it then shows "#N/A"; the same with function: NA(). What I am trying to do is to have a control button to show or hide a series from the ...
|
| Rearrange a formula | 05 Sep 2005 14:50 GMT | 3 |
How do I write a code to chart functions in this form After arrangement 2*x+xy = 4 >> y = (4-x)/x 3+xy +x = 0 >> y = -(3+x)/x
|
| Pivot Chart Total Columns | 05 Sep 2005 14:46 GMT | 3 |
I have a standard pivot table/chart combination displaying project costing&budget data for several projects. I would like to plot in the chart the sum of budgets and/or costs over different combinations of projects. But I only succeed in charting the individual entries per ...
|
| How to mix a stacked column and a clustered one on same graph? | 05 Sep 2005 13:41 GMT | 1 |
I want to display on the same graph 2 subtotal informations letùs say sub1 and sub2 for 10 years to show decrease of one and increase of the other in parallel. The best is then to used clustered column. But sub1 is build for 2 products5(A and B) and sub2 is coming from 3 infos D ...
|
| Linking Chart items to files | 05 Sep 2005 07:27 GMT | 2 |
Anyone got a clue on how to link each stacked bar(or similar) to a different file, so when someone views the file, he can click on the bar, to get a relevant document
|
| What is msoCanvas? | 03 Sep 2005 14:04 GMT | 1 |
What is a Canvas? Do I need that to draw lines, arc, etc? Johannes
|
| Charts | 03 Sep 2005 14:00 GMT | 3 |
How can I create a chart that shows two sets of data over time, one in columns, the other in a superimposed line?
|
| Can anyone align the numbers within the datatable of a chart? | 02 Sep 2005 18:41 GMT | 1 |
I have this request from 'the top' within my organization to align to the right the numbers on the data table of every chart we produce for our monthly reports. The charts are created with Excel. I tried to play with the macros, visual
|
| 3 month rolling chart | 02 Sep 2005 18:40 GMT | 4 |
I've looked at some examples but found myself lost. I have a sheet that shows overtime by department (those being the rows) by month (columns), and wanted to make a chart that will show a rolling three months for each department, so it would show August, July, and June, and next ...
|
| Excel Capabilities in Word | 02 Sep 2005 17:56 GMT | 1 |
Can a table created in Word do an Autosum (Excel) if so how or should the chart be created in Excel and then moved to Word, if I do that will the Autosum feature still work?
|
| I want to overlay three data sets in the same chart | 02 Sep 2005 03:45 GMT | 1 |
Imagine I have three regions and four variables. I am trying to show a comparative analysis of each variable but highlighted on a seperate vertical line that easily displays which region is which. Any ideas?
|
| excel should make it easier to have a 1 to 1 plot area in chart | 02 Sep 2005 03:43 GMT | 2 |
Sometimes I would like the plot area to have a 1 to 1 ratio, so each little square of the gridlines are a square. ie, the y- axis could be 10, the x- axis could be 10, so the plot area would be square, or the y- axis could go from -10 to 10, with the same x- axis, so the plot ...
|
| automatically update chart plotting current month and previous 6 | 01 Sep 2005 22:20 GMT | 1 |
I need to automatically update a chart every month for a report but I only want to plot the current month and six months back each time. For example Feb-Aug for the Aug report then for the Sept report plot Mar-Sept. Any suggestions?
|
| plotting time | 01 Sep 2005 22:17 GMT | 1 |
What is the best way to plot time series data? For instance, I have plotted columns of data against time using "X-Y (Scatter)" chart instead of "line" chart. Is one preferred over the other? Also, when adding additional data to the chart, I can use "Chart->Add Data", or I can ...
|
| Flying Bricks Chart | 01 Sep 2005 22:12 GMT | 1 |
Could anybody, please, give me the table with formulas, i.e. source for creating Flying bricks chart, or detailed decription of how to build one. Thanks,
|