Re: Change straight line to "blocked" one.
Hi Pieter-Jan, Take a look at the Step chart page on Tushar Mehta's site, (http://www.tushar-mehta.com/) Pieter-Jan wrote: > Hello, > > I would like to change a straight line between points to a...
Re: Excel Macros and Mega Stat
To use macros, set your security level to medium: 1. Choose Tools>Macro>Security 2. Select Medium, click OK There are some installation instructions for MegaStat here: ...
See the replys in worksheet.functions group. Please don't post the same message to multiple groups - it just fragments any responses you get, In article <email@example.com>, ...
Gap Width Problem with Dates
replies , 6/30/2003, 6:00:15 PM
On Excel XP, the column widths when graphing values has a problem when the x-axis labels are a date format. The gap width for a chart that uses numbers or text as x-axis labels can be set to zero...
replies , 6/30/2003, 7:17:41 PM
I am trying to develop a chart that can be used as an order form where the spreadsheet will POTENTIALLY add "item a" item b" and "item c" to deliver a total. For example: 4 pens @ 1.00 = 4.00 3...
simple bar graph not working correctly
replies , 7/1/2003, 12:59:07 AM
Trying to create a simple bar graph which i have done a thousand times.For some reason excel is seeing the first two cells in my row as the series. eg a2 contains the word express orders. B2...
Chart data refresh & printing
replies , 7/1/2003, 2:34:56 AM
In an XL2000 work book, I have a drop down validation box that selects a name from another sheet. After selection of the name, cells alongside that validation box are updated from that other sheet....
Re: Broken Lines in Line Graph
Hi Natalie, Instead of 'N/A' use the function =NA() This will cause the chart to join between the valid dots. Or if the cells are empty set teh Plot Empty cells as Interpolated. To do this select...
Trend line through the origin
replies , 7/1/2003, 12:09:09 PM
I have three points (sometimes four) on a scatter graph. I need the formula for the best fit straight line through them that also goes exactly through the origin (0,0). an example of data would...
replies , 7/1/2003, 4:03:21 PM
hi, i have a question regarding something i'm trying to chart. i have seven cells, all OLE linked to a program. thus, these cells change constantly. here's an example of what i'm trying to...
replies , 7/1/2003, 6:58:26 PM
If I press the space bar when over a protected cell it still disappears, how do I fix this? ALSO.. how can I copy and paste a worksheet complete with cell sizes, formulae and protections? ...
line chart problem: data points intersecting with border
replies , 7/1/2003, 7:06:25 PM
The first & last data points of my series are intersecting with the vertical border of the chart area. I'd like to have a bit of a gap (so I don't always have to reposition the data label for the...
replies , 7/1/2003, 10:18:58 PM
Is there any way to move mutliple cells from one column to another column without having to grab each individual cell. i.e. I want to move every forth cell in my A column (A1,A5,A9,A13 etc.) and...
Can't set alignment in Pivot Chart
replies , 7/2/2003, 12:40:17 AM
I have a pivot chart with 2 level category labels on the x axis. It looks a bit like this: 1/4 1/6 | 1/4 1/6 | 1/4 1/6 | 1/4 1/6 | Company A | Company B | Company C | Company...
Re: Zero data points
A few ways are: - Plot by named ranges, which you can redefine to contain only the amount of data you want plotted. - Format the x-axis of the plot to show only the desired plot range - Use #N/A...
Re: plot non.cintiguos range
The range you describe consists of adjoining cells, but the union makes them discontiguous in a way that Excel cannot deal with. You could do this a different way: Sub ChartIt() Dim srs As...
Copy multiple charts
replies , 7/2/2003, 8:33:43 AM
Y'all Does anyone know how to select all charts on a worksheet for copying en masse to WORD. The charts are layed out on the sheet and, currently, they are selected manually together (SHIFT+Select)...
Alignment of chart axes categories
replies , 7/2/2003, 10:11:31 AM
When trying to align the category labels on the Y axis of a horizontal bar chart all the first level categories are aligned horizontally, but secondary, or higher level categories on the same...
Charting through VB.
replies , 7/2/2003, 10:53:43 AM
Hi, I have run into a little problem while trying to update charts using VB and was wondering if anyone can help. Basically I have an excel 2000 workbook which is split into several different...
Re: formula changing
Brian - Your formula turns the result of the subtraction into text. I couldn't make it sum the results. Use a regular subtraction formula in the cell: =B1-A1 then apply this custom number...