Threads Replies Last Post 197 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>   Combining Workbooks I have 3 workbooks that I need to combine pages. 1 is data, 2 are charts with attached data. When I copy either of the charts, the data reverts to decimal, it should be in percent. How do I keep the data from changing... 1 5/17/2007 7:40:00 PM Forced Scaling I'm doing work with trying to model what a polygon would look like on an XY graph in Excel. This workbook will be distributed for use by many people, who can enter any range of points, and then a polygon will be created by using the XY line graphs. I have my polygon done, and everything looks alright. The question I have is, is there any way to force the XY graphs to always scale together? I ... 1 5/17/2007 5:33:40 PM Chart size Hi I am having many charts in many sheets in a workbook I want to have the same size of the chart I am plotting in the sheet not in a seperate window Any help Thanks in advance Jam ... 2 5/17/2007 4:15:38 PM graphs how do you add quadrant lines to a graph?... 2 5/17/2007 2:16:55 PM Avoid plotting refferanced blanks as zeros in scatter plot graphs I can not figure out how not to plot data that referances blank cells as zero's. I have a worksheet that links to tables with data orginized by size (mm) from big to small. This worksheet contains a scatter plot graph that looks at all sizes in the table. Typically not all sizes have data. The only way I can figure out to remove the zero values from the blank cells is by manualy sele... 18 5/17/2007 2:15:30 PM Data Lables, in chart go away when reopening I've got a pivot table with the sales reps name in the row, month sold in the column and for different sales figure "sums" in the data. I've created a standard column chart to compare these 4 different "sums" (which become my category axis), by rep for a given month and even though I format the data series to have data labels (value or $), everytime I close and reopen my workbook the ... 1 5/17/2007 1:01:01 PM Plot area distorted when I copy Excel chart into Powerpoint I am trying to embed an Excel chart into a Powerpoint slide. The chart is an object located on an Excel worksheet and is sized (5.45" x 9.3") such that no scaling is required in Powerpoint. I have the "lock aspect ratio" option turned on. Whenever I embed the chart into Powerpoint (by using copy --> paste), the size of the chart area is 5.45" x 9.3" (just like I want) but the plot are... 2 5/17/2007 11:56:42 AM zero value removes columns. How do I keep columns with zero value ..I have a workbook that run in Business Warehouse. I enter a date range, and several columns fill in. However, if one of the columns has a vlue of zero, the column will not display. Ex a workbook has col_a, col_b, col_c, col_d. If col_c has no data, the worksheet will only show, a, b, and d. I need the zero value in column D because I have chart data linked to the worksheet. If col_c do... 1 5/16/2007 8:10:02 PM drawing bell graphs side-by-side i'm trying to draw two normal distribution bell graphs side by side in a same drawing. i was able to draw two different bell graphs following the help provided earlier, but still cannot draw them together with some overlapping tails. perhaps, the difficulty i have is "selecting" the columns (range?) . i "selected" all four columns (two columns for taller graph, and the other two ... 8 5/16/2007 6:55:44 PM How do I change the default line colors in Excel graphs? I would like to use a color scheme that is viewable. Presently the first color selected by the program is light blue. How do I set the default colors to my choice? Can I set several color schemes for different end uses like printing versus projecting?... 3 5/16/2007 5:39:00 PM Side-by-side bar chart Hello. I'm using Excel 2007. The goal: I want to build a bar chart that has two bars for each value (one is volume, the other is effectiveness). Category Effectiveness Volume A 11.4% 398241 B 10.2% 364633 C 6.9% 49214 D 12.4% 32790 E 15.4% 14148 The problem: I can get the two data sets added with each... 3 5/16/2007 3:35:34 PM Bar Chart I would like to do a column chart that groups the bars representing the data points adjacently, for example: 3/2006 sales and 3/2007 sales / 4/2006 sales and 4/2007 sales, etc. Any ideas? ... 2 5/16/2007 3:57:24 AM Color vs Colorindex for series border Running on Excel 2003, I am attempting to set the .border.color property for an x-y scatter series object using a long value that was generated by the RGB function. However, the colorindex property seems to override it. I can successfully change the marker colors, but the .border.color value reverts back to the one associated with the colorindex value. I don't want to change the palette ... 2 5/16/2007 1:37:33 AM Dynamic Charts Problem I did some googling this weekend and found lots of helpful advice on how to make dynamic charts with named ranges and OFFSET, INDEX, and MATCH functions. Anyway, I was able to successfully create the dynamic charts that I wanted by pointing the series data at a named range. For instance the data range represented on my x-axis is derived from the named variable "rChartDates" which is defi... 14 5/16/2007 12:59:45 AM Cluster Column Pivot Chart I'm trying to create a column pivot chart that will have a different column for each category with in a group. I can genearte the pivot table so it comes out like this: Time Fruit Total Q1 sum of apple 3 sum of oranges 2 sum of grapes 2 Q2 sum of apple 0 sum of oranges 1 sum of grapes 3... 1 5/15/2007 10:10:46 PM How to group bars showing counts and overlay line compliance chart Using data similar to what's below (month, ticket count type, customer, SLA compliance %), I'd like to be able to have the bars with the # of tickets opened and closed for each month grouped so the bars touch each other while still having space inbetween each months' bars (using the 1st axis). I only can seem to find an option that determines the space between all bars...not allowing me... 5 5/15/2007 9:17:00 PM Slope line in stacked area chart How can I change the slope between two points in a stacked area chart to be a vertical line? My x axis is years, and where my data goes from 0 in year 1 to 100 in year 2, I get a slope upward --- but I don't want that; I want to see a vertical line as the beginning of the area, at the year 1 point. Thanks. -- Sue W.... 4 5/15/2007 7:12:59 PM Maintain formatting in linked chart title I am linking an Excel chart title to a named range. Is there any way to maintain the formatting used in the named range in the chart title?... 2 5/15/2007 6:07:34 PM calculate the area under the curve How can i calculate the area under the curve?... 3 5/15/2007 4:53:09 PM Color coded bar chart is there any way i can color code bars with reference to the y axis, without manualy changing the colors... 4 5/15/2007 3:07:05 PM how excel calculates the major units on an axis when MajorUnitIsAuto property set to true I need to know, how excel calculates the major units on an axis when MajorUnitIsAuto property set to true. We are porting an existing excel chart application to .net with help of a third party tool for charting. If MajorUnitIsAuto property set to true, excel automatically calculates the major unit.Need to know what algorithm excel uses to calculate the Major Units. Thanks in advance, Mat... 2 5/15/2007 3:06:48 PM Cannot assign a range to seriecollection values I use the following code to assign a range in my macro. I checked with other webite and the syntax seems to be correct. Activesheet.chartobjects("Chart 1").activate set rng = activesheet.range(cells(1,1), cells(x, y)) Activechart.seriescollection(1).values = rng x and y are variables I set earlier in the code. The error message I get is "run time error 1004. Unable to set the values pr... 4 5/15/2007 2:55:13 PM Using part of a cell in a chart title I have a chart which should get a title. However, this should be partly be used from a cell e.g. "counted with 5%" 5% should be taken from the cell and used in the title. Is this possible? ... 2 5/15/2007 8:44:23 AM how excel calculates the major units on an axis when MajorUnitIsAuto property set to true I need to know, how excel calculates the major units on an axis when MajorUnitIsAuto property set to true. We are porting an existing excel chart application to .net with help of a third party tool for charting. If MajorUnitIsAuto property set to true, excel automatically calculates the major unit.Need to know what algorithm excel uses to calculate the Major Units. Thanks in advance, Mat... 1 5/15/2007 7:39:52 AM Read series values range of a chart Is it possible to read the existing range defined in the values under source data/series/Values? The reason is that I have a checkbox to hide/show the value. Since I don't know the range, I want to read and put into a temp variable so that when the user wants to show it again, I can add my temp variable into the values box. Is it doable? Thanks... 3 5/15/2007 2:45:01 AM 197 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>