Hi, I am trying to create a simple scatter graph. The thing is, the requestor wants the data markers to vary, based on a 3rd value. Is there a way to do...

I've created a spreadsheet to track my weight and my BMI readings (for health (diabetes) and not vanity. I'd like the Y axis of my chart to show two...

I have a new worksheet for each day, labeled with the date. I want to pull data from the same cell (like "P-3") in each worksheet and put it into...

Hi, I have the following data: column A: jan feb mar apr column B:

I'm trying to create a custom graph which has both stacked columns bar graph and also a line graph. I know excel has a combination graph with a bar graph and a...

Hi, I've got 4 series of data, all of which I want to show on the same graph. 3 of these are horizontal straight lines (i.e. they have gradient of zero); the...

I have created a histogram of event frequencies (into numbered buckets e.g. 1-5, 5-10, 15-20, etc as x axis labels) using a barchart with zero gap width. I'd...

Hi, I'm working with pie-charts that have leader lines to each slice of pie. When I delete a leader line it causes the pie-chart to re-size. How do I prevent...

I'm selecting the 4th sub-type under "Line Chart." The data points appear but I want lines to connect the data points and lines do not appear.

Hi: I have a password protected chart. So, users cannot select any part of the chart. I want them to be able to change only the orientation of the datalabels...

Hi: I have a password protected chart. Users print it but do not edit it. Now, I want them to be able to edit only the position of the datalabels. How would...

Hi all, I'm attempting some code that will take the height and width values from an active Word table cell, and then use them to adjust the page margins of...

I currently havre a pretty basic graph with time on the X axis and sales along the Y. What I was wondering is whether there is a way to define certain events...

Hi, I have 2 fairly basic questions about chart formatting but Im a novice so please bare with me! 1. have createda column chart through the pivot table option...

hiya, im trying to create a pivot table where I can change my base data (inserting or deleting rows of data) and still have this reflected in the pivot...

Hi, I have a pivot table which changes in size depending on the selections made and the dynamic base data that is used. I want to set conditional formatting...

Hello, I'm using an OLAP data source for my pivot table and chart. When I select two different products their totals for each month are correct in the...

I want to superimpose a three band trading channel over the OHLC of my candle stock chart. I have read the E-Bible for 2003. Gone online to MS Help for...

Usually, I have to chart alot of data. I cannot really use color to distinguish the line and the line styles leave alot to be desired when the points are...

I wish to put two labels on a chart say a time function together with a quantity function against the same axis (usually x). I run Excel 2003