Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment
Is it possible to make a combination graph with a vertical line graph
included? It would appear you can only have line graphs which are plotted on
the y graph at the moment
You can use an XY Scatter chart instead, perhaps using a dummy series to provide
non-numeric vertical axis labels:
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
smithers2002 wrote:
> Is it possible to make a combination graph with a vertical line graph
> included? It would appear you can only have line graphs which are plotted on
> the y graph at the moment
Hi, Thanks, I looked at your site but the graph does not work. I am using a
100% stacked bar chart/stacked bar chart and need a vertical series showing
another value- when I try to do this, it keeps returning the values on a
horizontal axis. Please help, its really annoying me!
"Jon Peltier" wrote:
> You can use an XY Scatter chart instead, perhaps using a dummy series to provide
> non-numeric vertical axis labels:
>
> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> smithers2002 wrote:
>
> > Is it possible to make a combination graph with a vertical line graph
> > included? It would appear you can only have line graphs which are plotted on
> > the y graph at the moment
>
>
The XY Scatter chart series overlaid on the Bar chart has vertical Y and horizontal
X, while the bar chart series have vertical X and horizontal Y. For the XY Scatter
series, use a Y coordinate that goes from 1 to N, 1 corresponding to the lowest
horizontal bar category, and N to the number of categories. Use an X value
corresponding to the Y values of the bars.
This is the relevant page:
http://peltiertech.com/Excel/Charts/BarLineCombo.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
smithers2002 wrote:
> Hi, Thanks, I looked at your site but the graph does not work. I am using a
> 100% stacked bar chart/stacked bar chart and need a vertical series showing
> another value- when I try to do this, it keeps returning the values on a
> horizontal axis. Please help, its really annoying me!
>
>
> "Jon Peltier" wrote:
>
>
>>You can use an XY Scatter chart instead, perhaps using a dummy series to provide
>>non-numeric vertical axis labels:
>>
>> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>smithers2002 wrote:
>>
>>
>>>Is it possible to make a combination graph with a vertical line graph
>>>included? It would appear you can only have line graphs which are plotted on
>>>the y graph at the moment
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks