Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm trying to get a custom graph in Excel
I'm trying to graph the sales development of one sales territory when
compared to the overall sales development of the corporation; the Y-axis values should be in percentage, the X-value axis is in years 1995 through 2004. I like to have it graphed similar to a stock graph, however with both sales data starting at 0% and then showing an upper (+) or lower (-) sales development over the last 10-years. My problem so far is that the corporate sales is so large that the territory sales is too small and not very well visible. If I change the corporate sales by eliminating the last digit, I get a comparision, but it starts at whatever the sales is on the Y-axis instead of both data series starting at Zero. |
#2
|
|||
|
|||
The following should get you going:
Dual Axis Clustered Column Chart http://www.tushar-mehta.com/excel/ti...xis/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I'm trying to graph the sales development of one sales territory when compared to the overall sales development of the corporation; the Y-axis values should be in percentage, the X-value axis is in years 1995 through 2004. I like to have it graphed similar to a stock graph, however with both sales data starting at 0% and then showing an upper (+) or lower (-) sales development over the last 10-years. My problem so far is that the corporate sales is so large that the territory sales is too small and not very well visible. If I change the corporate sales by eliminating the last digit, I get a comparision, but it starts at whatever the sales is on the Y-axis instead of both data series starting at Zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a custom calendar in excel? | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Copy Excel Custom Menus to New Computer | Excel Discussion (Misc queries) | |||
Share Excel worksheet custom header/footer throughout workbook. | Excel Worksheet Functions | |||
Can I make a custom button in Excel for the Group feature? | Excel Worksheet Functions |