Re: chart on zero
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
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
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...
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...
Re: chart range selection
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 ?
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...
Using Indirect Cell References in a Chart
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...
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
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...
Re: xy scatter series formatting
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
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
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
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
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
Re: Return Sheet Name?
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
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
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
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
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?
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...