Chart Question - Please help

[LEVICC01]

Hi,

I am really struggling trying to figure this one out and am hoping that one of you guru's can assist me

I have 4 columns of data,

A = Title of issue,
B = Volume, (Bar Chart)
C = Cumulative % over total, (Line Chart)
D = Description.

I have created a Pareto Chart, Title (Column A) on the Horizontal axis, Volume up the left Vertical axis for and 5 on Right vertical axis.

I would like to hover my mouse over each of the Bars and would like it to display the description.

How can i do this easily?

Your help would be very much appreciated.

 

[Gerald Higgins]

In Excel 2003, when you hover over the bars in a bar chart, you get a small box which displays the series name, the point number or name, and the value.

You don't need to do anything to set this up, it all happens automatically.

 

[LEVICC01]

Hi Gerald,

It's that information you mention that i specifically dont need to be displayed, as the graph will already show that witht he axis and lebels.

It's the column not included in the displayed data i want to see. I.e Column 4 - Description.

Any ideas?

 

[Gerald Higgins]

Sorry I don't really understand what you mean.
Can you explain more please ?

 

[LEVICC01]

Sure )

This isn't the actual table, but if you use this as a starting point.

A1 = "Title",
B1 = "Volume of products sold", (Used for Bar Chart)
C1 = "Cumulative % over total", (Line Chart) (Ignore for now)
D1 = "Description" (of each of Column A titles) i.e what they mean.

For example,
A2 = Essential Items - D2 = Household appliances such as Washing Machines, Fridges, Cookers, etc).
A3 = Luxury Items - D3 = Items such as Dishwashers, Tumble Dryers, etc.
A4 = Entertainment - D4 = TV's, DVD Players, PCs etc.

When i highlight the volume in the chart for Essential Items, in this case data from cell B2 on the Bar chart, i want it to say "Household applianes such as Washing Machines, Fridges, Cookers, etc and nothing else."

Does that make more sense?