Hi I am trying to create a dynamic line chart for my home accounts in Excel 2007 SP1. I have data entered horizontally by month in a sheet called "Savings"....

I need to present a portfolio of loans on a bar chart for 4 end of months split into currencies (there 3 currencies). I created a stacked bar chart (a single...

Hi, I want to find the lowest point on the plotted line in XY (Scatter) graph. I have many points scattered above and below the line. I need the...

Thought I would see how to do this but need help. I want to show a horizontal bar that begins at time T1 and ends at time T2 (yes, the X-axis would be time...

I can draw a line chart o/k but not a graph that starts at x=0,y=0. Obviously, this is because the x axis in Excel is divided up into domains, from 0 to 1, 1...

i have created a few charts that use =offset and comboxes to display different data depending on which name is chosen. a b a b a 1 day 1 day 2 day 3 day...

I have basic data with a grouping ID for each series: 9.65 1 5.95 1 15.9 1 8.25 1 22.5 2 0.0 2 2.65 3 6.2 3 4.1 3

I am using Excel 2003 and my pivot chart is working fine. I have multiple data points in the data field. My problem is I would like it to chart all of the...

Hello, MS EXCEL 2003 on XP PRO. I want to create a graph with 3 series. I want one to be a Column and the other two to be lines. I use LINE-COLUMN out of...

I have created a cluster column chart based on start date of an event. I have 40 events I am reporting with different start dates. My series or bars are very...

Hi, I need to have my data table header row split into 2 separate rows. one for a name, the next row for their position. Is this possible, or will i have to...

Hi there, I have two columns I want to put into a graph. The first column is my posting date, which has approx 20 lines, beginning with Oct 1. The next...

Can anyone explain the following formula to me: =Data!$A$5:INDEX(Data!$A:$A,MATCH(9.99999E+307,Data!$A:$A)) I am setting up a dynamic chart and found help on...

Done Date client 1 1/1/08 client 2 3/1/08 client 3 7/23/08 etc... ect.... My spreadsheet looks like the above. I'd like to to create a line chart...

in B3 to M3 (=12cells) I enter data for 12 months in N3, I calculate the average of the 12months How will I get an average line in a graph from that single...

Hi everyone, I am having little problem with my stacked chart. I have 5 values aganist month i.e. Month on X-Axis, 5 values(Series1, Series2, Series3,...

I am using Solver and looking at the reports it produces. Can anyone explain the following terms to me: Reduced Gradient and LagRange Multiplier (Sensitivity...

I have create a gantt chart with three series, which is possible to do, however I have about 700 rows to chart, which makes the chart unreadable unless...

I want to change the order in which the entries appear in the legend in my Excel chart. How do I do this without changing my actual data? ( I did a seach and...

I am using Excel 2007. I have a table that I would like to move to another location on my sheet. From that table, a graph is created. I have selected all the...