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
_______
>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
Sabina - 28 Sep 2007 18:04 GMT
What about using the secondary axis? Is that possible?
> And which axis will your prices go on?
>
[quoted text clipped - 14 lines]
> > Is
> > this possible? What is the best way to do this? Thanks! Sabina