I don't know what to call this, but here is what I need: I have a trend line and I need to determine where it crosses zero. I want a vertical marker where the...

I want to compare TWO sets of data points, with error bars like the stock chart type ("high-low-close" subtype). I can graph one set but I can't figure out...

I'm trying to use an example in John Walkenbach excell2000 pp w/vba book on deleting charts: 'ActiveWorkbook.Charts.Delete' I have about 100 sheets that have...

I have a universe chart - basically a floating-stacked-bar chart that shows a colored sub-bar for each of four quartiles. There is one of these stacks of four...

Hi I have the following data, which is a range between two end-points for a number of cases. Case A: 50% to 75% B 25% 65% C 35% 85% and want to...

Dear All, I have a pivot table with pivot chart, I have to press the red exclamation mark to refresh the chart and table every time I want the situation to be...

Does anyone know how I can get my hands on the supposed flowchart data template that is supposed to exist inside Excel? According to my Excel 2000 help file,...

Hello, I could really use some charting help. Here's my data and what I'm trying to do. Cells A1:D1 contain sales for regions North,South,East,West and cell...

Hi there, I'm trying to print up a batch of tickets using each cell as a ticket. What I need to do is start with the number 1, and each successive...

Hi though not fully automatic (you have to do a manual refresh) consider using pivot tables for...

On one of our workbooks we have several graphs that pull information from the other worksheets within the workbook. When I click on the tab (worksheet)...

I need to know how to update a chart automatically so it will incorporate new months data as it is entered into a log. I have a data log with a complete list...

Hi, Using XL 2003. I have a workbook with 3 graphs. Two of the graphs are correct and they both source their data off of a particular worksheet. The third...

I have set up some macros with buttons on a chart to hide or display certain series on the chart. With too many series visible on the chart it gets messy so I...

Hi, is there any way to sort names in a table, alphabetically, and then have numbers in a bargraph go in descending order? Okay, I have a table with a list of...

Bob - You're not afraid of a little math, are you? Keep the original values in their worksheet location, say, dates in column A and stock values in B through...

I am monitoring several processes in which I am using line charts with date range on x axis and percentage on y axis. I have be asked to annotate process...

I have a line chart that has several series from a table in it for the source data. I would like one of those series to be a constant number throughout the...

Hello -- This charting application has the following features: 1 - user can "import" a time series (into a set of columns in a worksheet); the app...

Set up a range with your percentages. Say you wanted to identify 20%, 20-40%, and 40%. Put these numbers in the sheet: 0 0.2 0.4 And color the cells they...