Hi I want to give users an option of selecting a zone / parameter thru a control box. Based on the value they select, the chart should get displayed. How...

We have 2 columns A = Age groups - 7 different age groups denoted by 1 or 2 or 3 or 4 or 5 or 6 or 7 B = Gender - Denoted by 1=M and...

I'm trying to construct a template that does some data analysis and plots the results, and I am only one step away from getting what I need. The issue is...

I am trying to plot some data I have in a scatter plot. It contains several values that are positive and negative, but all of the negative values apprear as...

Hello, I am graphing a series of data in a bar format in excel. Some of the entries have no data. Instead of interpolating, graphing zero, or just leaving...

Hi, I have some stacked column charts and I want the data labels to appear just above each column. Is that possible? I'm using excel 2003 version and the...

I import data from either web query or database query so that I can run more advanced reporting from Excel. The problem is that depending on the source...

I have a workbook with 10 worksheets, all of which are similar. Each worksheet has a table and a graph. Each graph plots 11 data series, where the X axis...

I have a large spreadsheet that was created in Excel 2003. It includes a detailed chart that is part area chart and part line chart. When I open the file...

Has anyone encountered this? TIA - Bob Sub ColorBySeriesName() Dim rPatterns As Range Dim iSeries As Long Dim rSeries As Range Set rPatterns =...

I want to create a marginal abatement cost (MAC) column chart in Excel 2003. The data I am using is sorted for cost ($/tonne/year). Then I have a marginal...

I have a 10 step process. How do I give text "X" a 10% value on the spreadsheet so it will display as 10% for each completed step in a chart?

TWIMC I have a datalog which contains a large amount of info (+10000 data points). When I try and plot anything more than 1000 points in Excel 2007, the app...

I have 2 columns of 12 rows of data: 1 labeled for each month; 1 showing the cumulative count of steps completed. I want to show the data in a single column...

I have a user whose charts are slow to refresh. I have reinstalled Office 2003 and made sure it is patched. I have also tried logging on to the PC as a...

I am using Excel 2007 to display an X-Y graph and I want to force the Y scale to start at zero. How can I do that?

I have never experienced this before, but I have a user that is charting 12 months of data (columns) and four rows. She is doing a stacked column and...

I have a chart representing the following...

I know you can chart blank cells as spaces by clicking it in the options...this is a little different. The cell it is charting as an if function in it to...