| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
on bar graph, how to superimpose line of average values over bars
i am creating a bar graph with death rates for 8 cities in los angeles for a
particular disease. Now I would like to draw a constant line at a particular rate through the entire bar graph to indicate the target rate. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
on bar graph, how to superimpose line of average values overbars
Hi,
Rather than drawing the line using shapes, which will be static, add an extra data series. Here are a few pages on the subject. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Kavitha wrote: i am creating a bar graph with death rates for 8 cities in los angeles for a particular disease. Now I would like to draw a constant line at a particular rate through the entire bar graph to indicate the target rate. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
on bar graph, how to superimpose line of average values over b
Thanks that was very helpful. I got stuck on a minute detail: Label Last
Point. Currently the value of my horiz line is labeled at the 0 x-axis point and it is also labeled at the 1-axis point on my secondary axis. I was reading through the link titled "Label Last Point" but it is talking about creating a module. I'm not exactly sure how to do that. Any ideas? "Andy Pope" wrote: Hi, Rather than drawing the line using shapes, which will be static, add an extra data series. Here are a few pages on the subject. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Kavitha wrote: i am creating a bar graph with death rates for 8 cities in los angeles for a particular disease. Now I would like to draw a constant line at a particular rate through the entire bar graph to indicate the target rate. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
on bar graph, how to superimpose line of average values overb
You need to go to the VBE (visual basic editor) within excel ALT+F11
In the project window you should see your current workbook. Select it and then via the menus Insert Module. This will add a code module to your project. You can then copy/paste the code. Here is a non vba solution http://www.andypope.info/charts/Labellast.htm Cheers Andy Kavitha wrote: Thanks that was very helpful. I got stuck on a minute detail: Label Last Point. Currently the value of my horiz line is labeled at the 0 x-axis point and it is also labeled at the 1-axis point on my secondary axis. I was reading through the link titled "Label Last Point" but it is talking about creating a module. I'm not exactly sure how to do that. Any ideas? "Andy Pope" wrote: Hi, Rather than drawing the line using shapes, which will be static, add an extra data series. Here are a few pages on the subject. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Kavitha wrote: i am creating a bar graph with death rates for 8 cities in los angeles for a particular disease. Now I would like to draw a constant line at a particular rate through the entire bar graph to indicate the target rate. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line Graph with 2 lines | Charts and Charting in Excel | |||
| Different lines in a spreadsheet on the same line in graph? | Charts and Charting in Excel | |||
| line of best fit/reading values from graphs | Excel Discussion (Misc queries) | |||
| Line Graph Problem | Charts and Charting in Excel | |||
| How can i make values appear at the top of bars in a bar graph? | Charts and Charting in Excel | |||
Linear Mode
