Disabled "Switch Row/Column" when creating chart from a pivot tabl
Tue, 7 Oct 2008 03:18:07 -0700
I have a pivot table where there are week numbers and three different data
values pr week. This I want to graph so that the weeks are on the X-axis, the
values on the Y-axis and a legend telling which of the three datasets are
which.
When I create a Line graph the weeks are put as a legend and the X-axis h ...
|
Pivotcharts and stored procedures
Tue, 7 Oct 2008 02:03:01 -0700
i am writing a program in vb.net that uses pivotchart with backend sql
server........i.e.the data is fed into the pivot chart through a query from
the sql server........now i want to use my stored porcedure to populate my
pivot chart........is there anyways that i will be able to use stored
procedure to po ...
|
Horizontal and Vertical Charts
Mon, 6 Oct 2008 13:19:00 -0700
I have a user trying to create a contour chart or any chart for that matter
using values from different spreadsheets going horizontally and vertically.
These are well depths so, when one value ends vertically on one of the
spreadsheets the next spreadsheet begins horizontally. Is there a way to
effectively a ...
|
ploting points
Mon, 6 Oct 2008 11:01:02 -0700
How do I go about plotting points on a bell curve. I have 400 points to
plot. ...
|
Bell curve lines
Mon, 6 Oct 2008 10:05:01 -0700
How can I get the error line to form the 2 and 3 standardiviation points.
Also, how can I plot the 300 points
...
|
Show only workdays in chart axis?
Mon, 6 Oct 2008 09:52:03 -0700
Hi,
I have created a dynamic named-range that I use as the data source for my
scatter plot chart's x-axis. I only type in dates that are workdays in that
range.
When I graph my data the chart is still showing the weekends, just with no
data points in there. It is stretching my graph out and skewing the l ...
|
Changing an axis to show time with hour intervals
Mon, 6 Oct 2008 08:56:14 -0700
I am trying to create a chart from a spreadsheet of data that has 3 years and
all 12 months. Each month has different days and different times where data
was pulled. What I want to do is create a chart with all the months in the
data and have the axis showing time intervals of an hour each starting from
12:0 ...
|
|
|
How to create data for a smooth curve
Mon, 6 Oct 2008 00:17:01 -0700
I am trying to create a forecast for some data.
I have dates and quantity. When I plot it the graph is choppy. I can add a
trendline.
Is there someway for me to add the more important values, min, max a few
near the max, then get the values in between which would result in a smooth
curve?
...
|
Graphing 3 Relationships
Sun, 5 Oct 2008 21:56:11 -0500
I cannot figure out for the life of me how to graph the relationship between
Purchasing Power Parity ($) and Life Expectancy at Birth (Years), % Access
to improved water source, and Carbon Dioxide Emissions (per capita metric
tons).
Is there a way to utilize one graph to illustrate the relationships of these
...
|
How to insert a "Target" line into basic bar chart
Sun, 5 Oct 2008 11:52:01 -0700
Am looking for some info on how to insert a "Target" line into a bar chart.
I have a basic chart and would like to put on top of the data a line from
left to right which is the target, the bar data would indicate whether this
was acheived or not.
Am running office 2007.
Any help appreciated.
thanks ...
|
