Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Bar/Line chart---each with different number of data points | Charts and Charting in Excel | |||
joining data points on graph | Charts and Charting in Excel | |||
How do I find value on a graph between data points? | Excel Discussion (Misc queries) | |||
How do you set all graph data points to black (multiple series)? | Charts and Charting in Excel | |||
skip data points in graph | Charts and Charting in Excel |