Combination Graph with multiple data points
 

I am trying to create graph that has market areas (x-axis), brands (y-axis)
and one data set in columns for actual price and a line for budget price. Is
this possible? What is the best way to do this? Thanks! Sabina

Combination Graph with multiple data points
 

And which axis will your prices go on?

I would try this with different groupings of brands within markets or
markets within brands on the category axis, with different series for actual
and budget. The preliminary charts would show me how I really need to build
the "real" charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sabina" wrote in message
...
I am trying to create graph that has market areas (x-axis), brands (y-axis)
and one data set in columns for actual price and a line for budget price.
Is
this possible? What is the best way to do this? Thanks! Sabina

Combination Graph with multiple data points
 

What about using the secondary axis? Is that possible?

"Jon Peltier" wrote:

And which axis will your prices go on?

I would try this with different groupings of brands within markets or
markets within brands on the category axis, with different series for actual
and budget. The preliminary charts would show me how I really need to build
the "real" charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sabina" wrote in message
...
I am trying to create graph that has market areas (x-axis), brands (y-axis)
and one data set in columns for actual price and a line for budget price.
Is
this possible? What is the best way to do this? Thanks! Sabina