19356 posts
12589 users
Amarkumar - This is like a gantt chart. To get a single floating bar, you need to have two series charted on a horizontal stacked bar chart. The first series is the date and time corresponding...

Pivot Table Field Choices
1 replies , 7/2/2003, 3:12:31 PM
Is there a global way to uncheck ALL of the boxes in a pivot table field button pull down? I see the way to do this if you have 2 levels but all of mine are single level, and I have a hundred...

Graphing 2 sets of data
1 replies , 7/2/2003, 9:31:53 PM
Hello, I am trying to Graph the following data on a single graph. Amanda AB David A DA Nicole N NN Other O Total 12-Ju-03 34 47% 36 50% 0% 1 1% 72 13-Ju-03 60 45% 57...

Chart Date Label Problem - Is this a bug in Excel?
1 replies , 7/2/2003, 10:16:03 PM
I've created a chart with a 3 data series - one of which I am using as a dummy X axis (using categories, rather than values). The chart is XY scatter type. I'm using VBA to apply the values to the...

Points per pixel?
0 replies , 7/3/2003, 2:08:47 AM
Hello all, I am trying to get the points per pixel code going by doing this With ActiveWindow lWinWidth = .PointsToScreenPixelsX(.Selection.Width) lWinHeight =...

Milos Setek
Thanks Andy, I only discovered your reply today. I am not actually trying to have Excel animate the image. All I want to do is assemble the animated image parts in Excel, save as gif and then...

Column & Area graph combined
0 replies , 7/3/2003, 4:13:35 AM
I am trying to draw a column graph except I would like to be able to have the widths of the columns based on another data series so that I can compare the areas of the columns. Is there an add-in...

Auto Updating Charts
1 replies , 7/3/2003, 7:19:25 AM
Morning Ya'all, I am trying to set up an Auto Updating chart.. Basically, I have a spreadsheet that is constantly being updated. It's an appointment schedule of sorts, looking something like...

Automatic formatting of chart lines
2 replies , 7/3/2003, 8:48:51 AM
Hi I dont know if anyone can help, but I have a problem I'd like to resolve for work. We currently have a database which contains financial information, which we report on monthly by using Excel...

Percentage value labels on stacked bar chart
1 replies , 7/3/2003, 10:15:13 AM
Hi Another problem I have with charting. I want to preapre a stacked-bar chart of 5 different values, which is easy enough. However, I also want to show data labels of the percentage of the total...

I am working on a macro to convert small bitmap files into Excel xy-scatter charts, by using the markers as if they were pixels, for a lithograph type effect. In order to do this I need to put...

Link text box to a cell
3 replies , 7/3/2003, 5:11:05 PM
I have cell data that I would like to display in various locations on my chart. Can I link the cell data to a text box (or something similar)? Thanks!

I'm working in a workbook which is the database for an specific template. This workbook contains charts to display results. Every time I open the chart formating dialog box I get the message "No...

Plot every other cell
2 replies , 7/3/2003, 6:03:05 PM
I have a spreadsheet that contains half hour information. In a column, I combine numbers for two half hour periods to calculate an hourly number. I do this in every other cell. However, when I...

data points on a line graph
0 replies , 7/3/2003, 8:24:15 PM
I am in the process of writing my thesis for grad school and I am using graphs I created with Excel. I would like to insert the numeric value for each data point on the graph. For the post-test...

Bob Mahan
Linking to Excel Graphs
1 replies , 7/3/2003, 10:48:30 PM
I have a workbook with a worksheet that contains multiple graphs. I need to create OLE links to each graph and display the in object frames in a MS Access database. It seems that I need to be able to...

MVP's - Advanced Users
0 replies , 7/4/2003, 1:26:07 AM
Looking for people who might be interested in co-authoring or participating in a project with potential commercial exposure. You're very good at this thing called Excel. In fact, you're the...

Creating and setting location for Excel Charts
3 replies , 7/4/2003, 7:52:00 AM
Hi! I have to write some code that's supposed to create a report in Excel, where some of the reports will contain more charts and some less (because they have less data) and I have to create the...

Unabe to delete excel file from STS site...?
1 replies , 7/4/2003, 3:17:39 PM
Hello, does anyone know why I am not able to delete an Excel file containing macros from a document library within a Sharepoint Team Services site? Thanks very kindly, -Wil Adler

Wil Adler
example of league table
1 replies , 7/5/2003, 1:55:23 PM
Does anybody have a spreadsheet which I could use for running a small pool league. I am after a spreadsheet where I could import the games played and the points, win, loss etc for each...

john roberts