Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 102
Default How to scale the y- and z-axis of a 3-D Column diagram

Hi everybody,

I have a set of data, which is ordered by date and strike and show the
specific risk at that strike and date. I want to visualise these risk matrix,
to see the difference in time and strike (values from 0% - 200%) and the
y-axis should indicate the amount of risk in USD. My problem is, that the
difference between every date and strike is treated as equal, so I dont see
directly if there is one day or one year between two dates. How can I scale
all three axis in an 3-D column diagram, usually it's treated just in equal
steps as in the sheet like labels not like numbers.

Thx in advance
Benjamin
Reply
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 can I produce a diagram to scale James Excel Discussion (Misc queries) 1 November 20th 06 09:45 PM
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
How can I add third axis to the diagram? nemeza Charts and Charting in Excel 2 December 9th 05 02:22 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 06:51 PM.

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"