19356 posts
12589 users
Re: chart on zero
7 replies
It sounds as though the data are being imported as text, instead of numbers. To convert them to numbers: 1. Select an empty cell on the worksheet 2. Choose Edit>Copy 3. Select cells A1:A7 4. Choose...

creating gantt charts
1 replies , 7/5/2003, 10:39:17 PM
I have Excel 2000. Is there a way, using Excel, that I can create gantt charts or do I need additional software? What is the best way to create gantt charts for project management?

Re: Step chart
1 replies
Attachments are strongly discouraged in newsgroups, and generally hinder rather than helping you to get an answer for a number of reasons, including: - Many readers will not see your question at...

Re: Columngraph
2 replies
Hi, Thank you very much for your help, it works perfectly, I still have one question. I there a way to have always the same "color"format for the graph : this means the first column in the...

Depending on how the data are arranged, you could AutoFilter for the dates you want to show, or create a dynamic chart. A) You can create a chart from all the data, then filter the data to...

Create Excel Chart via COM ?
1 replies , 7/7/2003, 2:36:50 PM
Hi all I've had a look through MDSN but cannot see how you create an excel chart via COM ? is it possible ? I can see many examples on how to create and save a speadsheet file. Can someone send me...

Andrew Kennard
Using Indirect Cell References in a Chart
3 replies , 7/7/2003, 3:54:51 PM
I am trying to create a 'self-sizing' chart, but don't know if I can use indirect cell references in a chart. Here's the scenario: I have a tab with data(DataTable! A2:A20) and a tab with Graphs...

Chart presentation
1 replies , 7/7/2003, 6:29:15 PM
Is there any way to present a chart in excel, but without the excel window? Also I would like for the chart to be smaller in size, not the full screen. Any suggestions? Thanks. Deb

Stacked Bar Graph Displays Properly Prints Poorly
0 replies , 7/7/2003, 9:09:59 PM
I have built a stacked bar graph for a project timeline. It looks good on my screen, but when I print it the labels overlap each other and become unreadable. I have tried to resize the label...

Dan E
I've never seen shading to the left, but Jon Peltier has instructions for shading below a series: http://www.geocities.com/jonpeltier/Excel/Charts/NewStuff.html#XYArea He also has an add-in...

Text boxes in xy plot
0 replies , 7/7/2003, 11:46:14 PM
I have a large spreadsheet with lots of numbers and lots of xy plots. I find if I insert a text box tied to a cell into a chart (select chart,type=,select a cell,hit enter), from then on I can only...

Chart values default to 0 on the bottom
1 replies , 7/7/2003, 11:58:10 PM
I am creating a chart that will plot a series of numbers that are relatively close to one another, say 5 numbers that range from 6 to 7.1. When I chart it, the graph is rather smushed (flat)...

Stacked bar chart
1 replies , 7/8/2003, 4:45:49 AM
Could anybody tell me if it is possible to create a stacked bar chart with two Y - axis. In the custom chart option there doesn't seem to be this option. Regards John

Overlapping Labels
1 replies , 7/8/2003, 12:01:16 PM
I'm building charts with VBA and was wondering if there was a way to prevent data labels from overlapping one another when the data points are close together.

Micrsoft Peer-to-Peer Support
Nick Fuller @ BFA wrote: > Is there a way to return a sheetname in a cell? > > i.e ='sheetname' > > any help would be greatly appreciated. On Sheet2, enter: =CELL("address",'Sheet1'!A1) You'll...

Naming a chart
6 replies , 7/8/2003, 4:42:01 PM
How do I name a chart so that it may be referred to in VBA code? The Help documentation indicates that this may be done by selecting the chart and typing in the Name box. This did not work for me...

Chart appearance in WinXP vs Win2000
3 replies , 7/8/2003, 6:27:13 PM
I am using Excel 2002 (office XP) both at home and at work. My home machine has Win XP professional installed while my office machine has Windows 2000 installed. I have created several chart...

Inserting a Map of a state
1 replies , 7/8/2003, 5:45:08 PM
Does anyone know how to insert a map into a workbook. I thought that the icon looked like a globe or world but that was in excell 2000 and I couldn't find it in the version that came with office...

Y axis scaling
1 replies , 7/8/2003, 7:45:53 PM
I would like to set my value axis minimum to be 14.3 but I would like the scale to read 14.5, 15, 15.5 etc. (ie the X axis will cross at 14.3 but my first tick would be displayed at 14.5) Is this...

How do you 'reset' an Excel chart via COM?
0 replies , 7/8/2003, 8:46:58 PM
Hi Folks, I'm using an embedded Excel chart in an application which the user can change (via combo) what they want to graph. How do you reset the graph between selections? My original idea was...

Rob Pollard