I'm having troubles with creating some graphs with an Excel VBA Macro.
I would like to create about 35 graphs from a set of data stored in a unique
datasheet. As the set of data can change (length, numbers, etc ..) I created
a macro to generate the graph starting from a template ...

I need to export several tables and charts from an Access 2000 db into Excel
2000 because Access is very limited for displaying Charts. Ideally, I would
like to group data of a similar nature on the same sheet, tables down the
left side in blocks and charts adjacent. I can't seem to ...

How do I change the range of one item in a chart that has several items?
The X axis is time and the Y axis has several items.  I want to change the
range of just one of the Y axis items.
Thanks for your time,

Hi guys. I have a typical scatter plot, but I want to make it loo
unique, like it wasn't made with Excel. Why? Because I've been doin
this for years and I'm tired of the stock features, but I lack i
creativity. I've changed the font and removed the background color. I

I have been handling spreadsheets with 30,000 to 40,000 data points that I need
to work with (manipulate and graph). I am routinely crashing my computer  (a 2
year old Dell). As I contemplate a new computer, I am wondering if there are
any thoughts if a new Pentium 4 with 512 m of ...

I am looking for an automatic way to show a date in
Excel,  which is always equal to the business day before
the current date. "Now()-1" will work for the last 4 days
during the week. However, my problem is on Mondays. I need

How do I add a vertical line in a graph, that begins at the x-axis and continues to the upper limits of my graph? I need this line to cross a plotted logarithmic curve and display the y-axis value of the intersection of the vertical line and my logarithmic curve. This graph is to ...

How do you graph intra day data (Date, Open, High, Low,
Close) format. Where the Date includes the time: (2/22/04
9:00 AM format). Currently, I get a chart with all the
individual 30 min bars being grouped into just a daily

Excel 2002
I have created a Line graph to plot data over 52
weeks.  The x axis is Weeks and the y axis is Hours.  The
graph is a separate worksheet.I want to graph the data on

When I make a 3d plot of a data table, the Series (y)
axis insists on taking on the default labels s1, s2, etc.
I want it to display the values along the appropriate
edge of my data table. I can insert a reference one line

I would like to know how you can edit the chart legend.  
Have tried to double click and everything else, but
cannot change the legend.
Please help!

I have a spreadsheet that tracks the gas mileage for my vehicle and
displays it in a simple line graph.  I have moved to different parts
of the country a couple of times, and this resulted in noticable
changes to my gas mileage.  I would like to change the color of the

This one's for my 7th grader.  He's got events 1-14 in one
column.  He's got the value of each of those events in the
next column.  All of the values are positive.  The first
four values are zero.  We're using a bar graph.  He

I want to add error-bars to my pivot chart in the following context:
I have a pivot-table with the following fields:
- instance
- strategy

I am trying to create weather graphs from the data
gathered by my weather station. Wind direction is recorded
as one of 16 compass points (NE, SSW, ESE, etc.). I need a
method to convert these to compass headings or a way to