ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Plotting Chart with Two Values for Three Categories (https://www.excelbanter.com/charts-charting-excel/239025-plotting-chart-two-values-three-categories.html)

Safari

Plotting Chart with Two Values for Three Categories
 
Hi,

D S I
June-09 24 24 8
July-09 24 24 8

June-09 9,863,000 30,000,000 10,822,000
July-09 9,863,000 30,000,000 10,822,000

I want to create a single chart which can display two different values
for each variable (by using one scale on left side, another on
right).

So for June-09 for "D" there would be a value of 24 (for number) and
9,863,000 (for amount), for "S" 24 and 30,000,000 and for I 8 and
10,822,000. Build chart so I can add July, Aug. etc. data.

I've seen some hints on how to do this with a single item (like "D"
only) but not all 3.

Thanks!


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com