how do I show positive & negative numbers on a base line? Example: Col A Col B 100 200 300 200 I'd like to show a line chart that...

I have a dilemma I have a spreadsheet that only has a chart in it, that was linked to another spreadsheet. The other spreadsheet has disappeared (HD died...

I need to create a 2d bar graph with two different axis. I have used the secondary axis in the format series option but can not get the bars to display next...

When I make a 3D bar chart I cannot get the bars to reach to the horizontal line that refle cts the value. For example I have a value of 100,000 and the bar...

Is it possible to hide charts when there is no data to display? - all values = 0 is what I mean. Sandy

Hi, I am trying to make a templet for my school project. The file has number of questions with the answer YES and NO. If someone choose YES, I want to change...

Excel 2003 Hello, I am trying to lay out my data for a chart but am not able to get the desired results. I would like to be able to list minimum and...

Hi I am currently trying to chart two series: the first is series where the value are percentages and the categories are number ranges (e.g. "1 to 5", "6 to...

I have a chart that takes data from a list. Some of the data fields have #NA. How do I get i to ignore those details so it only plots based upon the true...

Hi All Is it possible through VBA to ask a chart for the name of the worksheet where it is sourceing its data? I have one worksheet with all my charts. Each...

To plot a graph with multiple series in Excel, I need to "Add" each series in the Source Data window. When I get to several series (5+), it gets difficult...

Hello, Is it possible to add/embed an annotation or a comment to an Excel 2007 Chart. For example, have a chart and then hover over a part of the chart and...

Can anyone tell me if possible wether there is a way to get excel to understand stones and pounds (base unit 14) i.e. 10.12 needs to be 10.twelve not...

Hello, Can anyone tell me if its possible for a scattergraph to display different groupings of individuals (business units) in another colour. The business...

I ve read from Mr Peltier's site about Changing the Default Font Autoscaling Behavior. Would appreciate direction on where to type in the --...

Hi I have a variable in cell A1, that I need to plot a histogram of. I need to create two axis to create a real time chart, where axis one will be an index...

I am trying to make a spreadsheet for my flying club.

Hello, I'm trying to create a multipanel chart or trellis display graph. I've seen the only two sites that talk about these and have examples,...

After drawing a histogram through data analysis, I want to draw a Gaussian distribution graph (standard or reverse bell-shape graph) relevant to my frequency...

I have 3 values for my x axis. With each value I have chosen the line graph. My 3rd value only shows the bullets and not the line. I have tried changing...