hi Would like pointing in right direction i have spreadsheet with data as follow column A (list of name) column B, C , D etc (labelled 1, 2 3 etc) data...

I'm trying to create a histogram for 50 values. I've put in the upper bounds as my bin values, as was posted by another user. However, the frequency output...

If I have 2 rows of data, say, A1 to C1 and A2 to C2 and record a macro :- Charts Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source...

Hello, I would like to create a "100% Stacked Column" Chart using the over simplified example below: % in 2002 $ in 2002 % in 2003 $...

When a chart is created it usually has a series of boxes that encompass the data contained in the chart much like it does with a SUM function. If these boxes...

I have a spreadsheet that I add new data to weekly. Is there a way to have the pivottables/charts refresh to include this data without recreating them? If I...

CAN ANYONE HELP ME I AM TRYING TO PLAN AN FIXTURES TABLE FOR TWELVE TEAMS WHICH EACH TEAM PLAY EACH OTHER TWICE 1st ONE AT HOME OR VICE VERSA! PLEASE CAN U...

Hi folks, This is how to create a custom format for use in chart labels. I have data already in the worksheet with decimal values e.g. ".25678%" I want this...

Hi folks, I am completing an Excel VBA project that creates custom chart sizes from a Library of existing pre-formatted charts by using the Move or Copy Sheet...

Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I...

Hi fellow MVP's, I am automating (VBA) bar charts in XL and have most of it under control but have one outstanding issue that It would appreciate comments on....

I would like to place two charts on the same chart sheet via VBA which I can do. The problem is in resizing the second chart. The logic I am using is...

Hi folks, I know that has been asked a million gazillion time but can't chase down a good solution, or missed it for an XL solution. Forget MS Grump. The...

Hi folks, I have an app that uses XL chart sheets rather than charts on a worksheet. I prefer that, but am not married to that. But kinda like the approach of...

Hi all, I understand the concept of conditional formatting in spreadsheets in XL 2003 just fine. Can the same functionality be extened to XL Charts? I am...

Hi! I have three columns of data each containing 84 entries. These are grouped in threes, and I wish to create a bar chart to show the comparison between...

OK, here is my problem....I am trying to create a dynamic x-bar chart and a dynamic moving range chart. I am using the StatPlus add-in and can't get this to...

I have negative numbers in a simple bar chart and the axis labels are crowding on top of the negative bars. I have the offset maxed out, however, in some...

Is there anyone in this group that can offer EXCEL expertise in an offline environment? I need some assistance in doing a chart. Thanks Brian

" Is there anyone in this group that can offer EXCEL expertise in an offline environment? I need some assistance in doing a chart. Thanks Brian