Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart
Dear all,
I have created a vertical bar chart to show monthly expenditure for the first four months of the year. Jan: £2.8m Feb: £2.65m Mar: £3.2m Apr: £2.95m etc... There is a constant monthly budget throughout the year and I wish to illustrate this by adding a datum in the graph. The cost ceiling in the above example would be £3m. How would I go about portraying this line on the graph? Thanks in advance, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart
Using the drawing tool bar, just add a line.
"Neil Pearce" wrote: Dear all, I have created a vertical bar chart to show monthly expenditure for the first four months of the year. Jan: £2.8m Feb: £2.65m Mar: £3.2m Apr: £2.95m etc... There is a constant monthly budget throughout the year and I wish to illustrate this by adding a datum in the graph. The cost ceiling in the above example would be £3m. How would I go about portraying this line on the graph? Thanks in advance, Neil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Chart
Hi,
Here are a bunch of ways of adding a datum. http://www.andypope.info/charts/averageline.htm Cheers Andy Neil Pearce wrote: Dear all, I have created a vertical bar chart to show monthly expenditure for the first four months of the year. Jan: £2.8m Feb: £2.65m Mar: £3.2m Apr: £2.95m etc... There is a constant monthly budget throughout the year and I wish to illustrate this by adding a datum in the graph. The cost ceiling in the above example would be £3m. How would I go about portraying this line on the graph? Thanks in advance, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Titles not showing in excel chart | Excel Discussion (Misc queries) | |||
Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel | |||
How do I resize a chart in Excel after the chart has been saved... | Charts and Charting in Excel |