Will anyone show me how to make a spreadsheet to show hourly wages or salary plus commision. I run a gym and hate there payroll system Employs are paid hourly...

Hi, I have a program that automatically sets the segments in a pie chart to the correct colour (set using RGB(c1,c2,c3)) see code below Charts("EPE...

I have 5 sets of data about 5 subjects (people) that I want to put into 1 chart. The dats sets are unrelated to each other & have different scales. I am an...

I am looking for a funnel chart for excel as opposed to making just a crude drawing with lines.

Hi all, I'd like my pivot chart to do 2 things: 1) If I select an item from one of my page field dropdowns, I'd like the dropdown items on another page field...

Hi all, Hope I'm posting in the correct forum. I'm trying to create a pareto chart (column and line) using Pivot Tables and I've got it 2/3 done. I'm stuck...

I need to have a bar graph with two data sets of different scales, yet when I change one data set to an secondary axis, the two bars combine. I need them to...

I have a custom chart template that I use. I want to share it with a coworker. How do I "export" it or copy it to their machine? TIA

Hi, I am get an "Unable to read file" error message when opening a Excel file that contains a PivotTable report. All the symptoms match microsoft support...

I am trying to use VBA to dynamically produce a number of charts. The number of charts produced depends on the amount of data that appears in a seperate...

I am trying to set up dynamic charts for multiple data arrays, but the OFFSET function will not return more than one reference. If height or width is not 1, I...

On my spreadsheet, I've got three columns (compass bearing from a smoke stack, distance from the stack, and smoke concentrations downwind from our stack). Can...

Whenever you create a line chart using excel 2000. The smoothline option is selected by default. How do I disable this? I want all my users to create a charts...

a

Hi to all, I pasted together the below attachment. Can anyone help me with it. I need to know how to start a second graph 55% of the way up the original...

I've figured out how to overlay charts, but can't figure out how to make my colored charts transparent so that the data from both charts can be read (like when...

I would love to know how to get Excel to read the coordinates at a point on a graph, BETWEEN the data points. Thanks muchly Jeff

I have a 3-Dimentional bar chart (x, y, and z axis). I need to stack the columns. How can I do this?

How do I truncate the y-axis of a bar graph if in the event that one data point is VERY high, and the others are very small? I would like to see the top of...