links in word not working for multiple graphs
replies , 7/8/2003, 9:05:51 PM
I have multiple graphs paste linked to a word document. They show fine but when going to print, the print shows the same graph repeated (ie, the wrong the chart) in a place where a different...
Re: SetNumberFormat("ddd") for chart x-axis
To get day of week names on x-axis, I set number format to 'ddd'. If the machine is set to use French language, it complains if it is set to 'ddd'. This is being done via software, not by hand,...
Zoom for Charts in XP
replies , 7/8/2003, 10:36:16 PM
I cannot get the zoom function to work with my charts in XP. Using Windows ME the zoom function works fine. However I have tried everything in EP and I cannot get the zoom function to work with...
Create a XY scatter plot with several series
replies , 7/9/2003, 12:35:01 AM
I am looking to be able to easily create an XY scatter plot where the points can be identified in to separate series by a catagorical variable in a third column. Right now I do it by sorting on...
Adding an intersecting line on a chart
replies , 7/9/2003, 8:15:39 AM
Hi All Sorry if this is simple but so am I ! I have a basic X-Y line chart with about 6 values plotted to form a wiggly line. I've added a trendline to this to smooth it. I now wish to add a...
Re: X/Y axis on floating bar chart
Hi Stefan, Create a floating bar chart then change the chart type to column. Right click chart and pick Chart Type from menu. Select Stacked column. Stefan Moser wrote: > Excel's floating bar chart...
replies , 7/9/2003, 11:30:37 AM
Hi, in order to draw a histogram I want to calculate the frequencies of a data matrix. I got the results in form of a vector on the dialogue window. How do I get this same vector in my excel...
Zoom Function on Charts not Working
replies , 7/9/2003, 1:28:10 PM
I have 2 computers. I have been using the zoom function on my older computer. However on my new computer the zoom function on the charts is not functioning. Office 2002 is installed on both...
replies , 7/9/2003, 2:14:45 PM
I followed all steps suggested by help, but still, I always get only the first value of the whole vector.
Exporting chart from Excel to Word
replies , 7/9/2003, 3:40:31 PM
Hi, I want to copy/paste a graph from Excel to Word. The only problem is that the file is too big, because each graph has 775 kb. How can I export just the graph, without the link to the document...
X / Y axis floating bar chart
replies , 7/9/2003, 5:36:54 PM
Excel's standard floating bar chart template allows only for horizontal bars, independent from the source data structure. Is there a way to 'rotate' the chart to show vertical bars?
Re: Displaying Values, %ages and Labels
Cassie - You could construct the desired text in a worksheet range using a syntax like this: =A2 & " " & B2 & " " & C2 where A2 has values, B2 has percentages, and C2 has labels. Then use Rob...
Excel Charts and Data
replies , 7/9/2003, 6:12:54 PM
This is my data: Jan 23 Feb 25 March 31 April 22 May 29 June 45 I need to construct a chart that reads from left to right, not from right to left as it does by default. How can...
Custom Chart Types
replies , 7/9/2003, 6:20:33 PM
I need to create a graph that does not currently exist in Excel. Is there a depot of custom graph that people have made? The two types of graphs I need are: Chart1: 2x Bar, 1 line Chart2:...
Re: Gauge Chart
Paul, Make a column chart with 1 y-value (2 if you want a stacked column as in the picture) Will send example by private mail. Bernard "PaulR" <p************ntlworld.com> wrote in...
Re: y=mx+b Graphing
Hey Dave - In cell A1 put your slope (m), and in cell A2 put your intercept (b). In cell C1 put the minimum value of X for your chart, and in C2 put the maximum value of X. In Cell D1 put this...
non-linear scale on Y-axis
replies , 7/9/2003, 11:18:15 PM
Is it possible to have a non-linear user-specified scale on a Y-axis? I have a column chart showing deviation from "normal". It has to have a positive and a negative. "zero" should be 100%. The...
file not found ChartIcn
replies , 7/10/2003, 5:40:17 AM
What does this mean, every time i start Excel i get a run- time error 53 message, and the choice to end or debug...HELP
Updating a chart Automatically
replies , 7/10/2003, 1:42:16 PM
Hi, i update a spreadsheet with new data from Access everyweek. I have a chart that displays the last thrity days, how do i do this automatically, so i dont have to keep updating the chart...
PIVOT CHARTS DEFAULT COLOURING
replies , 7/10/2003, 1:58:14 PM
I managed somehow to change the default colouring on a Pivot Chart, which kept the new colouring even when page changes were made. Unfortunately can't remember and according to HELP this can't be...