If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 scale in a single chart
I have 2 scale one in thousand dollars and the other one in million dollars.
Is it possible to place the thousand scale in the left column and the million scale on the right? However due to the huge differences. eg. the chart will plot from 3 thousand to 10 milion, you will see a big gap there. Which make the chart looks ugly. If only I can change the million units inbetween the thousand units. Can I change the different units in the right and left side of the scale? |
#2
|
|||
|
|||
2 scale in a single chart
It is not clear what you want and where you are stuck.
Do you want to know how to create 2 series one shown on the primary (left) axis, the other on the secondary (right) axis? If so, double-click the series you want on the right and from the Axis tab select the Secondary option. I don't understand the bit about big gaps and changing the millions inbetween the thousands bit. Can the right and left axis be scaled differently? Yes. I don't know when this was introduced but double-click the axis, then the Scale tab, then set the 'Display Units' from the drop-down box. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have 2 scale one in thousand dollars and the other one in million dollars. Is it possible to place the thousand scale in the left column and the million scale on the right? However due to the huge differences. eg. the chart will plot from 3 thousand to 10 milion, you will see a big gap there. Which make the chart looks ugly. If only I can change the million units inbetween the thousand units. Can I change the different units in the right and left side of the scale? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
chart data series -- plot a table as a single series | hjc | Charts and Charting | 7 | September 20th, 2005 05:52 PM |
can you create a break in the chart scale | duncanw | Charts and Charting | 1 | September 1st, 2005 10:51 AM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Excel construct single chart from 2 charts | Brian | Charts and Charting | 3 | February 13th, 2004 09:34 PM |