I was able to create a linear trendline for only portion of the data in my pareto (by adding new series), but the line always starts at the beginning of the...

I'm having trouble looking the DBF4 in the Files of Type window. I'm suppose to save a document in Excel into dbf format. How do a save an Excel document in...

I have a sheet with data in column A, e.g. rows 1 to 100 all have data, but row 10 to 30 need to be excluded because invalid (but are not empry!). This...

You cannot to my knowledge directly querry the XValues or Values from a chart series. For example, this does NOT work: Sub test1() Dim i As Integer With...

I use an excel file with 15 sheet, When I open the file now I have Dates appearing automatically on the graphs which have to be removed each time, please...

I have a bar graph showing the data that I want to see. Current data runs between say 389 and 1902. The quota for this data say is 1000. How can I insert say...

Hello everyone, I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the...

Hello everyone, I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the...

Is there some way I can set up a column chart without showing the space between the columns i.e. the columns are all right next to each other.

I am using Excel 2007. I am wanting to plot data for categories in a certain dept such as plumbing. I have about 10 different categories for which I plot out...

I put in 5 dates on the chart that I am using to track weight loss. When I add more dates in Excel the chart does not see them. What do I do?

Hello everyone, I am working on a little side-project for school. I would like to include an Excel spreadsheet that updates automatically depending on the...

Cannot format Horizontal label where axis is defined as $A$2:$B$30. I have the x-axis defined as 2 columns, but when I format the label, only the second...

I have a chart the shows analysis data of a chemical solution. Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on...

I'm a physics student trying to use excel for my experimental data. After inputting my values and their uncertainties (the error of the values), I plot the...

I need to display percentage numbers in a vertical axis showing the % sign beside the maximum number only. How do I edit this? 50% 40 30 20 etc Thanks

Hi, I am plotting large blocks of data on a scatter plot. I want to change my data and update though charts automatically so I use a series of if statements...

Quick question for the MVPs, like Jon P. and others. I have an Excel page with six dense XY graphs. But, each of these graphs are actually a picture of an...

Hello All, I want to plot a graph that sholud show different bands of ranges ex. A B C N1 12 35 N2 10 40 N3 71 95 N4 09 12 Now...

I am trying to create a chart showing a payment profile with a fixed start date but variable end. Manually, simple, select all cells with a date before the end...