Fill Part of Chart Background with second color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a line chart with stock by date. The chart goes from 1999-2006. I'd
like to color in the chart area from 2003-2006 without using any sort of
overlay or transparency, so it is behind the line data. Is this possible?
Thanks ahead of time for any responses!!
 
Thanks, that was a bit complex for what I wanted to do. I had a Friday
epiphany and just added another series behind the line chart series as a bar
chart, set the maximum height of the chart to the same as the top of the bar
chart values, set the gap to zero, border to none, and yipee, I got a filled
in area behind my line chart. But I did print out the response in case I
need to do a paneled pivot table (my brain dislikes pivot tables but you
never know)
 

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

Adding lines of data to an area chart 1
Conditional coloring of columns in column chart 2
Change background / color of chart worksheet? 3
Bizarre chart behaviour when changing axis cross at points 2
XL 07 - add color to specific part of plot area 1
Getting "Per Item" Pivot Chart Results when data rows are identica 4
Can you alternate background colors by gridline? 1
How do I partially fill a plot area with color? 4

Back
Top