Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How can I built a line graphic (one serie only) that as under the line a
coloured area without hiding the X and Y gridlines? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
As you are aware the trick of using an area chart to colour below the line will obscure the gridlines. Therefore you will have to create your own gridlines using more dummy series. See Jon Peltier's explanation. http://peltiertech.com/Excel/Charts/...Gridlines.html Cheers Andy Pedro Serra wrote: How can I built a line graphic (one serie only) that as under the line a coloured area without hiding the X and Y gridlines? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Area Charts - Filling in above only | Charts and Charting in Excel | |||
combination area and line needed | Charts and Charting in Excel | |||
"Pleading paper" in Excel? | Excel Worksheet Functions | |||
Program line when charting variances? | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |