Re: incorrect x-axis scale range
Matt - Do the dates 9/13/99 and 11/12/02 mean anything? That's what those numbers correspond to in Excel's date system, although they could just be numbers. Is there a default chart type that...
PIVOT TABLE - adding column
replies , 7/10/2003, 3:37:08 PM
Hi. I've created a pivot table from a spreadsheet of data. I need to insert a column into the created pivot table so I can add some values... but excel will not allow it. Does anyone know if...
Column Chart with data labels for percent and value?
replies , 7/10/2003, 6:11:12 PM
I want to create a column chart that displays data labels for both percent and value. Is this possible? Each column is stacked with 2 values, for instance: May '03 values: series A = 10 series B...
FORMATTING THE DATA SERIES
replies , 7/10/2003, 11:05:14 PM
Hello, How can I set the line and marker options to default to "AUTOMATIC" instead of "CUSTOM" in the FORMAT DATA SERIES - PATTERNS option? Thanks. :-)
Colouring Chart backgrounds
replies , 7/11/2003, 10:15:59 AM
Hello, I would like to colour the background of a chart with 3 different horizontal stripes of colour. I have tried drawing 3 rectangles on it but cannot send it to the back, therefore it covers...
Re: charting 0 values
Nathan - Are there zeros in the cells? Clear the cells, so they contain nothing. You may also need to change the way Excel is treating blanks: select the chart, choose Options from the Tools...
Re: Stacked bar chart in series
Hi Bud - You can make a clustered stacked column chart through clever arrangement of your data in the worksheet. See the details at Stephen Bullen's site: ...
Re: Seriescollection is different
Hi Monika - I suspect that the chart types are different, where you have a Line chart and the creator has a Scatter chart, or that you both have scatter charts, but the creator's Xvalues point to...
replies , 7/11/2003, 2:57:37 PM
I just got my copy of Edward Tufte's classic "The Visual Display of Quantitative Information." He suggests that instead of drawing gridlines across a bar chart, you erase a thin line through the...
Re: Finding the last row of chart....
Ant - Check out xlsChart.Parent.BottomRightCell - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Ant wrote: > Hi All, > > I'm creating...
Re: Plotting Empty Cells - HELP!
Rob - Even if it looks blank, a cell with a formula isn't, it returns "", which Excel plots as zero, like any text string. Replace the "" in the formula with NA(), which returns an #N/A error in...
Re: # of data points on a chart
Jason wrote: > I am charting overtime by departments, broken out by > quarters. My question is why is Excel not allowing me to > enter more than 10 data points into my current quarter > chart? As...
Re: Auto-sorting Charts
Randy S wrote: > How do I get a chart to auto-sort? If I have an array: > > Col A Col B > Joe Smith $52.89 > Jane Doe $14.62 > John Doe $99.42 > etc, etc, etc > >...
Skipping distance on axis; special bars
replies , 7/11/2003, 3:48:03 PM
Two more charting questions: 1. Can Excel skip some distance on its value axis? I have eleven series to plot, and one of them is ten times larger than all of the others. I would like the vertical...
Chart bug? Excel XP
replies , 7/11/2003, 4:20:51 PM
I've been running into a situation that continues to crash my Excel. I'm wondering if anyone else has encountered this. I often create text boxes that link to a cell in the worksheet to pull in...
Creating bar graph w/text filled cells
replies , 7/11/2003, 5:54:42 PM
Given a column with text in cells like the following: (a1)red (a2)white (a3)blue (a4)red (a5)blue how do I create a column chart that will show the first column with 2 reds, the 2nd column with 1...
replies , 7/11/2003, 6:27:53 PM
I have a large access database that i want to have a graphical display on a report. I want to be able to set it up so i can click a button and produce an excel chart on the report. From what I...
replies , 7/11/2003, 6:10:46 PM
I have read about the personal macro workbook . I cant find it in the XLStart folder . How do I create it. VAA
Re: XY Scatter chart
You can download Rob Bovey's XY Chart Labeler, a free add-in, from his web site: http://www.appspro.com/utilities/Labeler.asp Mike Watkins wrote: > The formatting of a xy scatter chart does not...
Removing Zero Percentages on a Pie chart
replies , 7/11/2003, 10:01:52 PM
How do I remove Zero Percentages on a Pie chart. When using percentages, even if the cell is blank it still show the Zero Label on the chart. Bob