Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Customising Charts
Good Morning, I have a chart showing different account information for different departments. I have 2 values per department, one showing value and the 2nd showing hours. Because of this I have created 2 axis. One going up every 200 and the second axis is going up every 5,000. The issue that I have is that I want the values to show side by side but it keeps changing so that the figures are in one line per department or one behind the other? Does anyone know how I can change this so that they sit side by side with 2 axis? Or even if it is possible. Many thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391 View this thread: http://www.excelforum.com/showthread...hreadid=500574 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Customising Charts
This web page shows how to fix the column chart:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "VickyC" wrote in message ... Good Morning, I have a chart showing different account information for different departments. I have 2 values per department, one showing value and the 2nd showing hours. Because of this I have created 2 axis. One going up every 200 and the second axis is going up every 5,000. The issue that I have is that I want the values to show side by side but it keeps changing so that the figures are in one line per department or one behind the other? Does anyone know how I can change this so that they sit side by side with 2 axis? Or even if it is possible. Many thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391 View this thread: http://www.excelforum.com/showthread...hreadid=500574 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
How To Change Fonts In Multiple Charts in a Workbook? | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) |