data table

I have a data table of students grades. In Row 1 I have the headers, in Row 2 I want "Points Possible" with corresponding numbers in each column. I want to be able to sort the grades without having the Points Possible row move when I sort it. I've tried Freeze Pane but it still moves when I...

Can someone please advise what the VBA code would be for a 2-way and 3-way data table.

In Excel2007, I have found that some of the data tables in new charts are combined with the labels on the primary (lower) horizontal axis. On others, there are both labels on the axis and on the data table. How can I consistently create graphs where the axis labels are shared with the data...

I have a graph which does a year on year comparison. I have added check boxes so users can select/deselect which years are displayed and attached code hides/unhides the relevant source data row which in turn removes/adds it to the graph. The source data number format is currency with a £...

Hi!! I make a Line/Bar mix chart using three columns. First columns contains differnt values, second and third column contain two different values.After plotting a bar chart,I convert the later two columns to line, as the later two colums are actually two different limits for the values of...

I'm making mixed Bar/Line chart.Amongst the three data elements,Two are Contant and are representated by line chart, The variable value is represented by Bar for different dates for entire month. for example that share value of a commodity changes every day (Bars) and govt regulatory caps on the...

I have data that requires a rate to be assigned to it according the a bill-to code and a product identifier. I thought to use a v-lookup, but don't think that will work since I have to look at two values before deciding which percentage to assign. The data looks something like this: Bill-to...

Hi all, I have developed a set of extensive macro calculations that I now want to trigger when a data table is created. These calculations have numerous inputs, and the idea is that the user should be able to use the data table function in Excel to vary any one of these inputs and record the...

I am trying to build a data table and on the horizontal and vertical axis, when i use a formula to derive the numbers, it messes up the results. It only works when I use hard values on the axis. How can I do this?

I have built a chart and am displaying the data table that is associated with that chart automatically. I would like to show the Totals for each column in the data table, but not show them graphed. Obviously that distorts the graph. Is there a way to manipulate that linked data table to show...

I have a 2d range which has some blank rows in it. I would like to be able to take the non-blank rows and consolidate them as a contiguous block in another range without disturbing the original table. Any ideas, anyone?