Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you build a chart with two differant number formats?
Help!!! I am a chart virgin!! I cant seem to figure out how to get 2 sets of
data that have differant measurement units on one chart. I have to create a chart that has whole numbers for call volume and percentages for service level. I want both of these on a bar graph. I have tried using the help screens that tell me to click on the second series and go to format/Data series. I have tried this however Data series is not an option showing under format. I only get the option for Selected data Labels and Sheet. I am using microsoft excel 2003. Thanks for taking the time to read this and if you can help, you are awesome!!! I have been working on this for hours!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you build a chart with two differant number formats?
Hi Scarlett
You have to plot one data series in the Main Axis (on the left side - the default) and the other data series in the Secondary Axis ( on the right side). So, one axis will have its scale in numbers and the other one in percentages. Try the following... Select one of the data series clicking in one of its columns. In the Format Menu, choose Data Series Selected. Choose the Axis Tab. Click in the Secondary Axis BOX Click OK. This probably will solve your problem. Bye Joe "Scarlett" escreveu na mensagem ... Help!!! I am a chart virgin!! I cant seem to figure out how to get 2 sets of data that have differant measurement units on one chart. I have to create a chart that has whole numbers for call volume and percentages for service level. I want both of these on a bar graph. I have tried using the help screens that tell me to click on the second series and go to format/Data series. I have tried this however Data series is not an option showing under format. I only get the option for Selected data Labels and Sheet. I am using microsoft excel 2003. Thanks for taking the time to read this and if you can help, you are awesome!!! I have been working on this for hours!!! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you build a chart with two differant number formats?
I have tried this however when I click on selected data series, There is not
an axis tab. In fact when I click on selected data series, a box named "format data series" pops up. In the box, I get access to the following tabs: Patterns ; Shape; Data Labels; Series Order; and Options. Am I doing something wrong? Thanks again for your help. "Joe" wrote: Hi Scarlett You have to plot one data series in the Main Axis (on the left side - the default) and the other data series in the Secondary Axis ( on the right side). So, one axis will have its scale in numbers and the other one in percentages. Try the following... Select one of the data series clicking in one of its columns. In the Format Menu, choose Data Series Selected. Choose the Axis Tab. Click in the Secondary Axis BOX Click OK. This probably will solve your problem. Bye Joe "Scarlett" escreveu na mensagem ... Help!!! I am a chart virgin!! I cant seem to figure out how to get 2 sets of data that have differant measurement units on one chart. I have to create a chart that has whole numbers for call volume and percentages for service level. I want both of these on a bar graph. I have tried using the help screens that tell me to click on the second series and go to format/Data series. I have tried this however Data series is not an option showing under format. I only get the option for Selected data Labels and Sheet. I am using microsoft excel 2003. Thanks for taking the time to read this and if you can help, you are awesome!!! I have been working on this for hours!!! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do you build a chart with two differant number formats?
On Sat, 31 May 2008, in microsoft.public.excel.charting,
Scarlett said: I have tried this however when I click on selected data series, There is not an axis tab. In fact when I click on selected data series, a box named "format data series" pops up. In the box, I get access to the following tabs: Patterns ; Shape; Data Labels; Series Order; and Options. Am I doing something wrong? Thanks again for your help. "Shape" is the clue. You're using a 3D chart type, and 3D, besides being bad information graphic practice generally, is also lacking in the ability to define second axes and Y error bars. Right click on the series, and instead of "Selected object", choose "Chart type" from the menu. Choose a two dimensional chart type from the picture menu of charts. Now do the "Format data series" thing again, and you should find the Axis tab is now available. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Calculations to build chart | New Users to Excel | |||
I need to build a graph Chart | Charts and Charting in Excel | |||
build a chart in a cell | Excel Discussion (Misc queries) | |||
how to build a chart? | Excel Discussion (Misc queries) | |||
are there conditional formats on charts ?(differant culomn color) | Charts and Charting in Excel |