| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Graph with shaded/colored Areas??
I would like to have a LINE GRAPH comparing Revenue vs Expenses. When the Revenue Expenses I want to shade the area Gray and when the Expenses Revenue I want to shade the area RED. Any suggestions? Very simple example would be: FY05 FY06 Revenue 100 200 Expense 50 250 Any help would be greatly appreciated!! -- rugby199993 ------------------------------------------------------------------------ rugby199993's Profile: http://www.excelforum.com/member.php...o&userid=15780 View this thread: http://www.excelforum.com/showthread...hreadid=475904 |
|
#2
|
|||
|
|||
|
Hi,
This example might help, http://www.andypope.info/ngs/ng21.htm Cheers Andy rugby199993 wrote: I would like to have a LINE GRAPH comparing Revenue vs Expenses. When the Revenue Expenses I want to shade the area Gray and when the Expenses Revenue I want to shade the area RED. Any suggestions? Very simple example would be: FY05 FY06 Revenue 100 200 Expense 50 250 Any help would be greatly appreciated!! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Having trouble going to your linked website, any suggestions? Is your server down? Thanks, Paul -- rugby199993 ------------------------------------------------------------------------ rugby199993's Profile: http://www.excelforum.com/member.php...o&userid=15780 View this thread: http://www.excelforum.com/showthread...hreadid=475904 |
|
#4
|
|||
|
|||
|
Site seems ok from here.
rugby199993 wrote: Having trouble going to your linked website, any suggestions? Is your server down? Thanks, Paul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
Andy, Is there any other way I could get the example you have? I would greatly appreciate it. Paul -- rugby199993 ------------------------------------------------------------------------ rugby199993's Profile: http://www.excelforum.com/member.php...o&userid=15780 View this thread: http://www.excelforum.com/showthread...hreadid=475904 |
|
#6
|
|||
|
|||
|
Email me and I will send it.
rugby199993 wrote: Andy, Is there any other way I could get the example you have? I would greatly appreciate it. Paul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
