| Thread | Last Post | Replies |
|
| Chart automation | 24 Aug 2006 21:48 GMT | 1 |
I have a spredsheet that keeps track of a number of sales items for every month. These sales numbers are also used for the sources in a chart that will give me a visual picture of what is going on. So, if the spreadsheet has numbers
|
| Format Chart based on data | 24 Aug 2006 21:48 GMT | 1 |
I have built a chart from a simple spreadsheet of data. Here is an example of the data: Group1 13.77 Group2 15.86
|
| how do I change cell references automatically in formulas | 24 Aug 2006 21:45 GMT | 1 |
In Excel 2000, I have data in 80 rows and 10 columns. Each week I add a new row. I have a separate chart for each column with the data range from the first row to the last.. Each week I have to change the data range to reflect the new last row for each chart. Is there someway ...
|
| Help on adding values to a bar chart | 24 Aug 2006 20:45 GMT | 3 |
Here is my problem. I currently have a bar chart that has 8 X-axis bars. I need to add 2 more to the X-axis. The labels for the x-axis are based on cells within another spreadsheet, but are not consecutive cells, they are spread apart. So when I go to add the two more cells,
|
| plot graph from multiple worksheet as embedded chart object on every worksheet | 24 Aug 2006 19:26 GMT | 3 |
Hi i want to plot the graph for every worksheet (column B and column D). I have more than 50 worksheets in the same workbook. How do i write a macro to ask the excel to plot the graph for every sheet and present the chart object on the same sheet? thank you very much for your help!
|
| xy scatter line goes below zero | 24 Aug 2006 16:50 GMT | 3 |
The line drawn in my xy scatter chart goes below zero of the y-axis, is there any way I can stop this? My first 3 points are all zero and then there is a very steep increase, the line that connects them assumes that there is a dip into negative values before the increase when ...
|
| Selecting chartobject without index no. | 24 Aug 2006 16:31 GMT | 4 |
I have 25 worksheets each with 2 graphs. I need to revise the source series for all the graphs in these worksheets. I thought I can use VB language to auto change the series reference but I do not know the index number for each of the chart
|
| How do I set up one chart for multiple worksheets? | 24 Aug 2006 13:30 GMT | 2 |
I have four worksheets with totals, I would like to create one chart for the total of each individual worksheet. Can I do this?
|
| 3D charts and limit lines | 24 Aug 2006 13:16 GMT | 2 |
I have to make some 3D columnn charts, because my charts scale must me between 0-300,000 and my values are somwhere between 10-50. I know it's insame, but is a must. On 2D chart I can not see a thing, But in 3D is somewhat acceptable.
|
| How do you save and share "user-defined chart type's" in Excel? | 24 Aug 2006 08:46 GMT | 1 |
We have created chart types and data formats that are in alignment with our company brand and we would like to add these user-defiined chart types and data formats to other employee's machines to use. However, we do not know how to do this. Does anyone know?
|
| Simple graph | 24 Aug 2006 08:43 GMT | 1 |
I have a range of data corresponding to several years: Year Amount 1997 100 1998 150
|
| Using Formulas with Charts | 24 Aug 2006 02:19 GMT | 1 |
I have a chart that references cells with the following formula =if(a1="","",a1/a2). The formula is used for each month Jan-Dec. I would like to copy the formula across all months. When I do this my data point show as zero for months that have not happened yet. What can I do ...
|
| Logarthium Graph | 24 Aug 2006 02:16 GMT | 1 |
Can you create a logarthium graph in excel. ie. having the x axis as a logarithum.
|
| How do you set up a Pivot table. Ccan't make it work | 24 Aug 2006 02:15 GMT | 1 |
I have never done one before. No matter what directions or instructions I read or follow or templates I use, I can make a simple Pivot Table! A simple report of 4 fiscal quarters. I'm about to scream.
|
| How can I create a pie chart without duplicating my cells? | 24 Aug 2006 02:13 GMT | 1 |
I am trying to create a pie chart with very simple data. Excel is duplicating my cells. For instance, if column B has the Company B listed 15 times in different rows it is creating 15 of Company B in my pie chart. Please HELP! mj012905@yahoo.com
|