| Thread | Last Post | Replies |
|
| Getting Trend Line Info from Chart | 06 Aug 2008 16:56 GMT | 11 |
I am creating a manpower report and updating learning curve charts for a decision making tool through VBA. The issue I am having is the trend line (Power) in the charts gives me the output I need but I cannot figure out how to pull the values I want into the spreadsheet. I have ...
|
| Graphing points to the 10^-19 | 06 Aug 2008 11:33 GMT | 14 |
I have the home and student 2007 version. When graphing a scatter graph with the Y axis having 10 to the negative power, excel doesn't show the values on the y axis. It only shows the 0 intercept value. I've tried editing the axis values but the number still doesn't display and ...
|
| Dynamic chart title | 06 Aug 2008 09:54 GMT | 2 |
I see several post on how to make dynamic chart titles. When I try to input = cell-reference, Excel either treats this like text or exits the text box and selects the cell instead. It does not work like normal cell input. I'm using Excel 2007. Any clues?
|
| Dynamic chart pasted to a new workbook in report can't be dynamic | 06 Aug 2008 05:15 GMT | 2 |
Is there a way to copy a dynamic excel chart into another workbook preventing the pasted one from changing when I update something in a corresponding table of the original chart? I would like to paste it as an object or image, whatever but it can't change
|
| Creating "cliffs" in an area chart | 06 Aug 2008 03:00 GMT | 2 |
I am trying to put together a chart that creates "cliffs" when I change from one value to another. For example I have the following data: 6/1/2008 350 6/23/2008 350
|
| Column Chart with multiple vertical axis | 06 Aug 2008 02:58 GMT | 1 |
I tried building a chart that displays 1 series in dollar sales and 1 series in unit sales. I tried putting one on a secondary axis, but it always overlaps the columns and changing the series overlap setting doesn't seem to have any effect? Does any one know what is going on and ...
|
| How do I set up formulas to update graphs dynamically | 05 Aug 2008 18:56 GMT | 5 |
I have the following information I need to graph date Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 burn 116 23 254 inventory 3035 3011 2757
|
| how to indicate on chart which axis (primary or secondary) in use | 05 Aug 2008 15:20 GMT | 1 |
Excel 2007. How can i indicate on a chart which series is using which y-axis when I have a secondary axis? For example I have several series on a line chart, some using the primary axis and some using the secondary axis. If I use the legend
|
| chart type does not correspondent with what I choose | 05 Aug 2008 14:53 GMT | 1 |
If I want to make a chart in excel 2007, I go to insert, scatter, and click on the first pictogram: markings without lines. But each time I do this, I receive a chart, WITH lines. Is this a known problem, and are there work-arounds or patches?
|
| hyperlink to a chart | 05 Aug 2008 13:48 GMT | 1 |
I have a workbook with multiple charts as their own worksheets. I have a navigation page in which i wish to put hyperlinks to the various charts however, when I go to the hyperlink window it does not recognise the charts as worksheets therefore I cannot select them to bookmark or ...
|
| Slider Bar | 05 Aug 2008 04:29 GMT | 4 |
Can someone tell me if I have to use VBA to add a slider bar or should I be able to find it on one of the tool bars? Also, where is a good place to learn about its use. Thanks
|
| How do I adjust&save the PivotChart format? | 05 Aug 2008 02:47 GMT | 2 |
I can adjust my PivotChart format (like background color, line color, scale etc) in the current view. Once I change the layout or refresh the chart, the format will revert to the default one. Is there a way that I can customize the PivotChart format and save it for
|
| how to draw a curve from data in excel? | 04 Aug 2008 18:51 GMT | 2 |
I would like to draw a curve from two series of data by using excel. Series of Price and Quantity. Thank for helping me
|
| Copying Charts | 04 Aug 2008 16:07 GMT | 3 |
I have created a worksheet with about 10 charts on it. I want to replicate it over a further 11 worksheets (one for each month), but when I do the charts always refer back to the original worksheet and I have to chabe each chart. Is there a way around this?
|
| When clicking on a chart, how do I make it come to the front? | 04 Aug 2008 03:13 GMT | 1 |
Greetings all! I am working in Excel 07. I have many charts on each worksheet and I have them overlapping to minimize the amount of scrolling I have to do. In previous versions of Excel, if I clicked on a particular chart it would come
|