Hi, I have a chart which relies on the data in a table with 29 rows. Occaisionally, I want to only use 28 rows as my data set for the chart. I can...

Two questions: 1) Is Sheets(1) not a worksheet? 2) Does this work: With Sheetbasis Set srceRange = .Range(.Cells(2, 2), .Cells(8, 2)) End With

I have complex charts, with many data points. The redraw time on my machine in Excel 2003 (all updates for office and wxp installed) is 2-3 sec, which...

I was wondering if I could get some help on how to create a CVP graph in Excel 2007.

How can I create a time-date graph such that the values are plotted at the correct time positions within the date range rather than all on the date vertical...

Does anyone know how to create the notches in the vertical box whisker charts? An example can be found in figure 10 of the following...

I created and saved a user defined column chart that included text boxes on the chart. However, when I used this chart to create a new one, the text boxes...

I've done this hundreds of times in 2003, but in 2007 I'm hitting some snags. I think it has to do with the chart styles found in excel 2007. I'm trying to...

I have a worksheet which contains 7 charts: 1st Chart = Chart 12 2nd Chart = Chart 7 3rd Chart = Chart 11 4th Chart = Chart 13 5th Chart = Chart 24 6th Chart...

How can I get my data from being displayed on the Y Axis to moving it to the X Axis? Thanks

I have many sets of data for which the x-values run up from approx 60 to 100, and back down to 60ish. Each set of data consists of 200 points. I can happily...

I am managing a database of lab results for an external company. That compnay recently upgraded from Excel 2003 to Excel 2007, which resulted in the...

I want to just label and highlight the min and max values in an XY chart and have them move appropriately if the data change. i saw a tutorial on line about...

I'm trying to draw a venn diagram in Excel, to show where survey respondents have responded 'yes' to two questions. Microsoft Help refers me to the picture...

While I may be missing some points, it seems the easiest way would be: A) Get all normalized data into a SQL server table; B) Produce datasets with 'select...

billdierker wrote: I accumulate incoming data into Excel and it looks like this: January February March etc. Account # ...

Greetings. (help) I need to develop a chart that graphically depicts an employees start time and end time each day. This chart would be a bar chart. The...

when showing data labels within a chart i only want to show a maxmium & a minimum not all the values \. can this be done thanks

I have a worksheet full of raw data and other worksheets which are just charts based on the raw data. I continually add more data to the raw data worksheet,...

When doing an X-Y scatter plot with large block of contiguous data separated by large gaps with missing data, the plot suddenly switches from a scatter plot to...