LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 57
Default Colour plot area of a dual axis x,y chart

Hiya all

Has anyone got a cure for this???

I have an xy scatter chart which has both primary and secondary axis. In the middle of the plot area i have an area (bounded by a data series line on all sides) that I want a different colour.

I have browsed the site and see a couple of options but they require the secondary axis to be an area chart. This causes my xy chart to fail as it needs both axis.

Once the chart is coloured it will be used as a printing template so no longer needs to function at all. The chart was designed in excel so that it could be dragged to the correct size whilst maintaining accurate calculated dimensions (So i tried exporting the chart to paint and colouring that way, this solved the colour issue but when I pasted back the chart the quality had diminished).

Is there a way to either
a. colour the chart but keep both xy axis ?
or
b. is there a better user friendly drawing software I can use? (A trial version would be fine as I only need to do this once).


Heres hoping!

Nobby
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you show plot area only-no chart area SteveOz Charts and Charting in Excel 1 September 19th 07 10:06 AM
Resize plot area in a chart area Darlene Excel Discussion (Misc queries) 0 July 10th 06 02:50 PM
How to increase chart area without affecting plot area? [email protected] Charts and Charting in Excel 2 April 21st 06 09:05 PM
Resize chart area without resizing plot area Janwillem van Dijk Charts and Charting in Excel 2 August 2nd 05 01:52 AM
How do I alter plot area colour in a chart without a mouse? debbiecatal Charts and Charting in Excel 2 May 30th 05 04:11 AM


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"