VBA
New Member
- Joined
- Jan 19, 2009
- Messages
- 39
Heya,
I googled around and used the excel help-function, but I must be using the wrong terms for I found nothing on this subject![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I would like to put different data in one and the same graph. For example, I'm graphing costs against mont AND working hours. The costs are way, way more (in millions) than the working hours (in thousands).
With only one y-scale bar (left) such a graph might give you insight in the costs, but makes the differences in working hours unreadable as they're so low on the chart and seem to be at the same height all the time.![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Is it possible in excel to have an y-scale (left) for series 1, and an y-scale (right) for series 2?
Or should I just make 2 transparent graphs and place them on top of one another?![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks in advance![Big grin :biggrin: :biggrin:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I googled around and used the excel help-function, but I must be using the wrong terms for I found nothing on this subject
I would like to put different data in one and the same graph. For example, I'm graphing costs against mont AND working hours. The costs are way, way more (in millions) than the working hours (in thousands).
With only one y-scale bar (left) such a graph might give you insight in the costs, but makes the differences in working hours unreadable as they're so low on the chart and seem to be at the same height all the time.
Is it possible in excel to have an y-scale (left) for series 1, and an y-scale (right) for series 2?
Or should I just make 2 transparent graphs and place them on top of one another?
Thanks in advance