Graph to display Range Label and Mean

N

NCSaint

Hi

First time poster...I searched but could not find the answer. I suspec
I have a very "easy" graph request but can't figure it out. What
would like to graph is a a bar chart I think..

Data will be Meal Prices and I want to show a single bar graph with th
range label at each end and the mean as a thin line where it would fal
within the data. Idea is also to have this as a dynamic table that wil
update with each change of data.

$3, $7, $9, $5, $8 with mean = $6.

Attached file for reference

Thanks
NCSaint/Steve

+-------------------------------------------------------------------
|Filename: range and mean.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=704
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data read from exponential graph 0
Plotting Line Graphs to Specific Bar Graphs 0
How do you make a hole in a line graph? 2
Frequency Graph with Multiple values 0
Bar Chart with Data Elements 1
Overlay line graph points on bar graph 1
Changing the setting of X,Y axes 0
Pie Chart and Table Query 2

Top