Hi, I'm trying to create a scatter chart and enter about 100 data series (a name, x value, y value for each). I could do it manually but I'm sure there's a...

Hi all Nice site, I'm like the all the stuff you got here! Anyway, an interesting problem to tickle your brains: I've got a bunch of charts on a page that I...

Hi, i have two questions: 1) does anyone know how to create a broken scale for the X axis (without drawing them in using the line function)? 2) I have on my...

Hi everyone, I am having trouble with some vba code to add error bars to a new series I am creating. When I run the following code I get a 'ErrorBar method of...

This may be really simple, but here is my situation, and what I am trying to accomplish: I'm trying to create a chart that will show the probability of...

I want to paste an Excel chart from worksheet 1 to worksheet 2 and for the newly pasted chart in sheet 2 to reference the sourse data as worksheet 2 not its...

Hi, I have a problem with vertical lines in an excel line-chart. I have checked the available information in excel charts, but it does not work (Jon’s Excel...

I'm trying to create a chart using the same cell reference in several worksheets. Does anyone know a quick way to do this?

Is there any way to use Search and replace options in case of Graphs and Charts.

How can I have a chart that *only* plots series chosen by the user. For example: I would like to have a on/off (1/0) switch for each series of data. I want...

I made a chart with days of the year, projected dates for things and actual dates that they happened. I was wondering if i could put a "running line" that...

Excel - 2003 or previous. Conditional formating on cells is useful but I would like to see this on graphs as well. For example in a bar graph chart the series...

When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty...

Can anyone recommend a procedure for creating large format scaled charts? Ideally, I'd like the y-axis to have a scale of 5 inches per unit and an x-axis of 1...

Does anyone know how to get the values I assign to the y axis scale remain static. I don't want them to be automatically changed as excel does. Thanks! Julie

In Excel, I am drawing normal distribution charts (your typical bell-shaped curve) using a column of x values and a column of y values, and selecting x-y...

Given a data set from 1983 to 2000, I would like the x-axis labels to be 1985, 1990, 1995, 2000. I know how to make Excel only show every 5th year, but I don't...

I can't figure out the VBA code that will return the address of the range of data plotted on an embedded chart on say sheet1. Everything I try just results in...

Hi, I want to transfer some charts (as picture) in excel to a particular word document (specific page and specific position). The word document already has...

It appears that while the radar plot can accept thousands of data points, it is only capable of displaying a maximum of 360 discrete circumferential point...